Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.