Forum Discussion
Date table with fiscal week numbers
Hi Can i get some advice on how to write a date table with fiscal week number please . our company fiscal week starts on the first week of april and ends on the last week of march the following ...
Hi Anonymous ,
Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.
mwegener
Most Valuable Professional
Most Valuable ProfessionalHi Anonymous ,
take a look at this solution.
https://community.powerbi.com/t5/Desktop/Creating-a-fiscal-week-column/m-p/556549
DAX:
Fiscal Week =
VAR __fw = [WeekNum] - 32 + 1
RETURN IF(__fw<=0,52+__fw,__fw)