Forum Discussion
AtchayaP
Helper V
3 years agoFiscal year, month dax
I'm doing a project I want to calculate fiscal year , fiscal month , fiscal week using weekend date
this project fiscal runs may 1 to April 302
i have data from 2020 to 2023
can I know how to calculate
1 Reply
- lbendlin
Super User
Don't do it. Don't do it in DAX. Don't do it in Power Query. Use an external calendar table. It will save your sanity.