cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

How can i get the Previous month sales.

Hello everyone please help me on this case.
 
How can i get the previous month sales by region.
 
Thanks advanced!!!

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: How can i get the Previous month sales.

Hi Arul,

 

 

Measure = Calculate(Sum(Sales),Parallelperiod(Date,-1,Month))

 

Hope it will solve your prob ,

if not let me know

 

View solution in original post

Highlighted
New Member

Re: How can i get the Previous month sales.

hai baskar,

            Thank you very much .... Its more helpful for me

 

View solution in original post

5 REPLIES 5
Highlighted
Microsoft
Microsoft

Re: How can i get the Previous month sales.

You can use the PREVIOUSMONTH function:

 

https://msdn.microsoft.com/en-us/library/ee634758.aspx

 

 

=CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), PREVIOUSMONTH('DateTime'[DateKey]))

 

Thanks,
Sam Lester (MSFT)

Highlighted
Resident Rockstar
Resident Rockstar

Re: How can i get the Previous month sales.

Hi Arul,

 

 

Measure = Calculate(Sum(Sales),Parallelperiod(Date,-1,Month))

 

Hope it will solve your prob ,

if not let me know

 

View solution in original post

Highlighted
New Member

Re: How can i get the Previous month sales.

hai baskar,

            Thank you very much .... Its more helpful for me

 

View solution in original post

Highlighted
Frequent Visitor

Re: How can i get the Previous month sales.

What if the previous month is in the previous year. For example, I tried your formula but I have sales for January 2017 and I want to see sales for December 2016. For some reason the formula does not return a result when there were sales for that product in the previous period. Any suggestions?

Highlighted
Super User I
Super User I

Re: How can i get the Previous month sales.

is your data type set correctly?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors