cancel
Showing results for
Did you mean:
Highlighted
New Member

## How can i get the Previous month sales.

How can i get the previous month sales by region.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
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

Highlighted
New Member

## Re: How can i get the Previous month sales.

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

5 REPLIES 5
Highlighted
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

## 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

Highlighted
New Member

## Re: How can i get the Previous month sales.

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

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

## Re: How can i get the Previous month sales.

is your data type set correctly?

Proud to be a Super User!

Announcements

#### 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

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

#### Community Blog

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

#### Community Summit Australia – Join Online!

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

Top Solution Authors
Top Kudoed Authors