cancel
Showing results for
Did you mean:
New Member

## Percentage change Present month and previous month

Hi All,

I want to calculte the previous month and present month sales . Also  i wanted to  calucate percentage change.

Kindly provide me the steps or sample pbix

Regards,

Ranganna Naik

2 REPLIES 2
Solution Sage
``````// Assumption is you have a custom-made calendar
// that holds the required pieces of time, among others,
// months. The Date field stores datetimes and is
// the key to the table. The table is also marked
// as the Date table in the model. Each indiviual month
// has a unique MonthId that runs from 1 to the number
// of months in the calendar (not just 12, we're talking
// about different months throughout years).

[Measure PM] =
IF( HASONEVALUE( Calendar[MonthId] ),

CALCULATE(
[Measure],
)
)

[Measure MoM%] =
IF( HASONEVALUE( Calendar[MonthId] ),

var __currentValue = [Measure]
var __priorMonthValue = [Measure PM]
var __delta = __currentValue - __priorMonthValue
return
divide(
__delta,
__priorMonthValue
)
)``````

Best

D

Super User III

https://powerbi.tips/2016/07/measures-month-to-month-percent-change/

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Announcements