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 Ashish_Mathur 

 

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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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 ,

     

    Its not giving the correct totals what I want. Thank measure change my month totals as well.

  • 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.