Forum Discussion

cham's avatar
cham
Icon for Post Patron rankPost Patron
4 years ago
Solved

Previous Month to Date

Hi I have a issue with Matrix table sub total,   I have craeted below measures Amount Sales = SUM(Sales[Amount]) Prev Month To Date = IF([MTH]=1, 0, CALCULATE ([Amount Sales], DATEADD(Calender...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    cham Try:

    Measure Total =
  VAR __Total = SUMX(SUMMARIZE('Table',[End of Month],"__PrevMonth",[PreviousMonthMeasure]),[__PrevMonth])
RETURN
  IF(HASONEVALUE('Table'[End of Month]),[PreviousMonthMeasure],__Total)
cham's avatar
cham
Icon for Post Patron rankPost Patron
4 years ago

Hi Greg_Deckler 

 

Please see the screesnhot below,

2020 year total is giving e the corrcet sum of 2020 months

 

But the measures I used to get the previous month value is correct. Every month is giving the previous month value but the Total of all the months values showing in sub total is incorrect.

 

WhatI can do for that.

 

thanks.