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,
Please can someone help me with this DAX measure. I am trying to get headcount in 13 rolling months such that when I select any months, it shows me the preceding 12 months. I have tried using most solutions online and still have not gotten an answer. this seen to be the only one that works on my measure However, some of the values for the headcount arre wrong for some months. What do you think is wrong with the measure?
Headcount Rolling 13 Months :=
VAR MaxDate = MAX(Dates[Date])
VAR MaxDate13MonthsAgo = EOMONTH(MaxDate, -13)
VAR Result =
IF (
HASONEVALUE("Duplicate date table [YEARMonth])") &&
MAX('Duplicate date table'[Date]) <= MaxDate &&
MAX('Duplicate date table'[Date]) > MaxDate13MonthsAgo,
CALCULATE (
[Headcount],
FILTER (
ALL (Dates[FY Month], Dates[Financial Year], Dates[YEARMonth]),
Dates[FY Month] = VALUES('Duplicate date table'[FY Month]) &&
Dates[Financial Year] = VALUES('Duplicate date table'[Years])
)
),
BLANK()
)
RETURN Result
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |