topic Re: Percentage change Present month and previous month in DAX Commands and Tips

Percentage change Present month and previous month

Anonymous — Tue, 30 Jun 2020 06:25:02 GMT

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

Re: Percentage change Present month and previous month

Anonymous — Tue, 30 Jun 2020 08:58:02 GMT

HI Anonymous ,

Have a look at this article

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

Regards,

Harsh Nathani

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

Did I answer your question? Mark my post as a solution!

Re: Percentage change Present month and previous month

Anonymous — Tue, 30 Jun 2020 12:20:27 GMT

// 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], DATEADD( Calendar[Date], -1, MONTH ) ) ) [Measure MoM%] = IF( HASONEVALUE( Calendar[MonthId] ), var __currentValue = [Measure] var __priorMonthValue = [Measure PM] var __delta = __currentValue - __priorMonthValue return divide( __delta, __priorMonthValue ) )

Best