Forum Discussion

AtchayaP's avatar
AtchayaP
Icon for Helper V rankHelper V
3 years ago

Fiscal 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 

 

 

amitchandak 

1 Reply

  • 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.