Forum Discussion
Last 12 Months
Hi Experts
i cannot understand why i am getting constant on the previous 12 months DAX Measure when i add the measure to my calender table....to see the end results...
Rolling 12 till last month FEP =
VAR EndDatelastMonth =
EOMONTH(TODAY(),-1)
VAR StartDate =
DATE(YEAR(TODAY()),-12,1)
VAR Result =
CALCULATE(
[MONTHLY TOTAL (FEP)],
DATESBETWEEN( 'Calendar'[Date], StartDate, EndDatelastMonth )
)
RETURN
Result
That is because the measure is not taking into account the calendar table, it is using fixed values. If you want to show the total value for the previous 12 months taking into account your calendar table you can use
Rolling 12 till last month FEP = VAR EndDatelastMonth = MAX('Calendar'[Date]) VAR StartDate = DATE(YEAR(EndDatelastMonth) - 1,MONTH(EndDatelastMonth),1) VAR Result = CALCULATE( [MONTHLY TOTAL (FEP)], REMOVEFILTERS('Calendar'), DATESBETWEEN( 'Calendar'[Date], StartDate, EndDatelastMonth )) RETURN Result
