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.
I have recently written a blog post to customize the fiscal week. Please check it out here - https://www.goodly.co.in/calculate-fiscal-week-in-power-bi/
- You'll have the option to customize the fiscal year start month.
- And starting day of the week - Eg. mon, tue etc..
Just copy the DAX code and create a new column in your date table and paste it there! It should work fine!
Let me know..thanks
This is *exactly* what I was looking for, and my fiscal year even starts in April and my fiscal weeks on Mondays, so that was serendipitous! Thank you so much!