Return FiscalMonthNum Dynamically

[Anonymous]

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 screenshot below:

[Stachu · Accepted solution]

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.