Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NPArulventhan
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
Baskar
Resident Rockstar
Resident Rockstar

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

hai baskar,

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

 

View solution in original post

6 REPLIES 6
Baskar
Resident Rockstar
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 

 

1431952_0-1635396723201.png

 

 

1431952_1-1635396775403.png

 

Could you please help me troubleshoot these ?

ldiaz
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?

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!




hai baskar,

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

 

SamLester
Employee
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)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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