Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I'm trying to create the following formula (YTD Leavers / FY month we are in * 12) / YTD AVR Headcount
I have created the [YTD Leavers] & [YTD AVR Headcount] measures but am not sure how to create the
[FY month we are in * 12]
I have a dedicated calendar table with month names and month numbers, our FY starts in September so its month 1
how can I have a measure that returns the month number based on the month that we are in multiplies that with 12 and returns value?
Thanks,
Kris
Solved! Go to Solution.
Forgot the "* 12". 🙂
FY month we are in * 12 =
CALCULATE ( MAX ( DimDate[Month Num] ), DimDate[Date] = TODAY () ) * 12
Proud to be a Super User!
Try this measure. I'm assuming that [Month Num] is the fiscal month number.
FY month we are in * 12 =
CALCULATE ( MAX ( DimDate[Month Num] ), DimDate[Date] = TODAY () )
Proud to be a Super User!
Forgot the "* 12". 🙂
FY month we are in * 12 =
CALCULATE ( MAX ( DimDate[Month Num] ), DimDate[Date] = TODAY () ) * 12
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |