Forum Discussion
Function To Calculate Fiscal Week
Hi all, I want to calculate the number of weeks based on the date of sale, I used the formula: week = WEEKNUM(Scorecard[SalesDate],2) This works very well but not for what I need, Due to work ...
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