Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Return FiscalMonthNum Dynamically

Hi    How could i go about returning the FiscalMonthNum dynamically using a measure, its October so i need it to return 8 for me, next month i would need it to return 9 automatically, see screensho...
Show and Tell
  • Stachu's avatar
    Stachu
    7 years ago

    you need to reference TODAY(), e.g.

    Measure = MOD(MONTH(TODAY())-3,12)+1

    will give 8 in October, 10 in Dec, 11 in Jan, etc.

Stachu's avatar
Stachu
Community Champion
7 years ago

you need to reference TODAY(), e.g.

Measure = MOD(MONTH(TODAY())-3,12)+1

will give 8 in October, 10 in Dec, 11 in Jan, etc.