Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more

Reply
Anonymous
Not applicable

Return FiscalMonthNum Dynamically

‎10-19-2018 07:59 AM

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:

 

Capture

Labels:
Message 1 of 2
593 Views
0
1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

‎10-19-2018 08:12 AM

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.



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

Message 2 of 2
587 Views
1 REPLY 1
Stachu
Community Champion
Community Champion

‎10-19-2018 08:12 AM

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.



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Message 2 of 2
588 Views

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All