Week Number of Financial Year in Power BI - DAX Solution

In this video, we return the week number of a financial year in Power BI.

The financial year begins on the 1st October and we want to return the week number from that date with the week beginning on a Monday. This video explains how to achieve this and customise it for your financial or fiscal year.

There is the WEEKNUM function in DAX, but that returns the week number for the calendar year only. We need to return when the week containing the 1st October begins, and start counting from that date.

Video timings.
00:00 - Financial year week number scenario
02:21 - Week number of calendar year
02:55 - Start week number of financial year
04:19 - Calculate financial week number in Power BI
05:21 - Checking the fiscal week number results

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ►   / alanmurray-computergaga  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1