How can i get the Previous month sales.

[NPArulventhan]

Hello everyone please help me on this case.

How can i get the previous month sales by region.

Thanks advanced!!!

[Baskar · Accepted solution]

Hi Arul,

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

Hope it will solve your prob ,

if not let me know

[Baskar · Accepted solution]

Hi Arul,

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

Hope it will solve your prob ,

if not let me know

[Anonymous]

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 

Could you please help me troubleshoot these ?

[ldiaz]

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?

[vanessafvg]

is your data type set correctly?

[030350]

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?

[NPArulventhan · Accepted solution]

hai baskar,

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

[SamLester]

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)