Forum Discussion
cham
Post Patron
Post PatronPrevious 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...
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
Community Champion
Community Championcham Try:
Measure Total =
VAR __Total = SUMX(SUMMARIZE('Table',[End of Month],"__PrevMonth",[PreviousMonthMeasure]),[__PrevMonth])
RETURN
IF(HASONEVALUE('Table'[End of Month]),[PreviousMonthMeasure],__Total)
chamPost Patron
Post Patronhi Greg_Deckler ,
Its not giving the correct totals what I want. Thank measure change my month totals as well.
- Greg_Deckler
cham Can you post sample data as text so that we can replicate the issue?
- cham
Hi Grey Your measure worked on this. Thank you so much for your help.