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)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

cham Can you post sample data as text so that we can replicate the issue?

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

Hi Grey Your measure worked on this. Thank you so much for your help.