cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## How can i get the Previous month sales.

How can i get the previous month sales by region.

2 ACCEPTED SOLUTIONS
Resident Rockstar

Hi Arul,

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

Hope it will solve your prob ,

if not let me know

New Member

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

7 REPLIES 7
Resident Rockstar

Hi Arul,

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

Hope it will solve your prob ,

if not let me know

Anonymous
Not applicable

I have been trying this method, and also using previous month function on Power Bi Sample Financial Data , but have not been getting any values

Frequent Visitor

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?

Super User

is your data type set correctly?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

New Member

what is the correct data type for this formula?  I have date as calendar and Amounts as mesure or Number of pages as number.  I do not have any return.  May youplease advise?

New Member

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

Microsoft Employee

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)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors