Forum Discussion

RichOB's avatar
RichOB
Post Partisan
1 year ago
Solved

DAX 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?

 

Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago
    Fiscal Month = 1+MOD(MONTH(EDATE([Date],-4)),12)
     
    or
     
    Fiscal Month = 1+MOD(-4+MONTH([Date]),12)

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    Fiscal Month = 1+MOD(MONTH(EDATE([Date],-4)),12)
     
    or
     
    Fiscal Month = 1+MOD(-4+MONTH([Date]),12)