Forum Discussion
RichOB
Post Partisan
Post PartisanDAX Fiscal Month
What DAX would give me a fiscal month number column so April was 1 and May was 2 etc, so I could then sort a graph by Fiscal Month please?
- Fiscal Month = 1+MOD(MONTH(EDATE([Date],-4)),12)orFiscal Month = 1+MOD(-4+MONTH([Date]),12)
1 Reply
- lbendlin
Super User
Fiscal Month = 1+MOD(MONTH(EDATE([Date],-4)),12)orFiscal Month = 1+MOD(-4+MONTH([Date]),12)