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.
PattemManohar
Community Champion
Community ChampionMrMarshall Just want to be clear on this - WeekNum column has Calendar Year WeekNumber isn't it ?
FiscalWeekNum will be the weeknumber starting from April to End of March. In that case how come, Calendar WeekNum 1 has FiscalWeekNum 14.
MrMarshallHelper II
Helper IIThx for anser PattemManohar,
Yes, WeekNum is calendar Year Weeknumber.
The financial year is starting in October, hence on Week 40.
There for, WeekNum 40 should be Fiscal year 1.
And if we continue to count, Weeknum 52 should be Fiscal year 13, and Weeknum 1 should there for be 14.