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,
Probably I simple question for which I didn't find an exact solution.
I have simple "hours measure" calculated from hours table and I have Date table. I need to have a Hours LTM cumulative which does not destroy my slicing on my graphs. My current Hours LTM DAX:
Hours LTM = CALCULATE (
[Hours];
DATESBETWEEN (
'Date'[Date];
NEXTDAY(SAMEPERIODLASTYEAR ( LASTDATE ( 'Date'[Date] ) ) );
LASTDATE ( 'Date'[Date] )
)
)
Gives wrong figures and extends the graphs x-axis (months) to be 4 years long even though I have sliced it with Date slicer for 2 years long period. In below pic the x axis is months, green line is monthly hours and black line is the LTM hours. the last point of green line should be the highest or almost hte highest point of black line but it is the opposite. And the black line should be only as long as the green line which is correctly sliced by Date slicer on the page.
By LTM I assume you mean "Last Twelve Months" and not "Long Term Memory" or "Life Time Fitness"?
You might check out my Rolling Months Quick Measure here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Rolling-Months/m-p/391499
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |