Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

PreviousMonth Calculation

Hello,

 

I have a very simple messure:

TotalSalesBlue = SUMX(FILTER('Sales','Sales'[COLOR]="BLUE"),'Sales'[AMT])

 

Sales Table is connect with Date Table via DateID.

 

I'm trying to find Only PreviousMonth, PreviousQuarter Data using Following formula:

PreviousMonthBlueSlaes= CALCULATE ([TotalSalesBlue] , PREVIOUSMONTH(DATE[Date_Id]))

 

I'm geeting all the months, but I'm only looking for previous month sum.

 

Thanks in advance.

Need Help

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    If you modify your TotalSalesBlue measure to this, do you get the correct result.

     

    =CALCULATE(SUM('Sales'[AMT]),'Sales'[COLOR]="BLUE")

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Even after modifying the result I get all month


      1- Changed messured as you suggested, still getting all months as shown below. I'm need to only get 9/30/2018 data.