Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power Bi Fiscal week column from Week Number

I want to build a calendar with below Fiscal WeekNum.     DAX QUERIES used to create calendar table   dimDate = ADDCOLUMNS ( CALENDAR ("01/04/2019", "31/03/2020"), "Year", YEAR ( [Date]...
help in dax Function
Help me please
help needed
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
6 years ago

how about this:

FiscalWeek =
IF (
    'Calendar'[WeekNum] < 40,
    'Calendar'[WeekNum] + 13,
    'Calendar'[WeekNum] - 39
)