Forum Discussion
Solved
Creating a fiscal week column
Trying to create a Fiscal week column from WeekNum in my Calendar table. I got the WeekNum done already. Fiscal year starting on Week 40, so I am trying to create something like the one below: I w...
MrMarshall - Not sure what went wrong, take a look at this PBIX file attached. Table3.
It looks like you missed the if statement.
A little ugly, might have to account for 53 week years although that wouldn't be the end of the world.
Fiscal Week = VAR __fw = [WeekNum] - 40 + 1 RETURN IF(__fw<=0,52+__fw,__fw)
Thx for answer Greg_Deckler,
I am afraid I didn't get the query to work the way it should have. I get the results below.
