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)
Ashish_Mathur
Super User
Super UserHi,
I am confused but I'd also like to help you. Please show clearly in an MS Excel file, the result you are expecting.
chamPost Patron
Post Patron
Please find the below details,
This is the Power BI table - which is not givingthe current SUB total of 2019 months
This is the excel data set, Power BI sub total needs to be as below highlited total.
Thanks,
- Greg_Deckler
Community Champion
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
hi 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?
- Ashish_Mathur
Hi,
Share the link from where i can download your PBI file.