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