cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: PreviousMonth Calculation

Hi,

 

Explore relative dates filters

4 REPLIES 4
Highlighted
Super User
Super User

Re: PreviousMonth Calculation

Hi,

 

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

 

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

Anonymous
Not applicable

Re: PreviousMonth Calculation

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.

post.jpg

Super User
Super User

Re: PreviousMonth Calculation

Hi,

 

Explore relative dates filters

Community Support Team
Community Support Team

Re: PreviousMonth Calculation

hi, @Anonymous

You may try to this way as below:

Step1:

Add a year month column in date table

Year Month Number = YEAR ( 'Date'[Date] ) * 100 + MONTH ( 'Date'[Date] ) 

16.JPG

Step2:

modify the formula

PreviousMonthBlueSlaes = CALCULATE ([TotalSalesBlue] , PREVIOUSMONTH('Date'[Date]), 'Date'[Year Month Number]=YEAR(TODAY())*100+MONTH(TODAY())-2)

Result:

17.JPGBefore18.JPGAfter

 

Best Regards,

Lin

 

 

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.