Forum Discussion
MrMarshall
Helper II
Helper IICreating 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.
Greg_Deckler
Community Champion
Community ChampionA 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)
MrMarshallHelper II
Helper IIThx 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.