Forum Discussion
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 screenshot below:
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.
1 Reply
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.