Forum Discussion
Rolling LTM with slicer
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.
1 Reply
- Greg_Deckler
Community Champion
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