topic Growth percentage calculation for current month using last month cost in DAX Commands and Tips

Growth percentage calculation for current month using last month cost

saiprathapdp — Sat, 11 Sep 2021 00:34:02 GMT

Please guide me to calculate growth percentage for below scenerio.

Billing Date cost Customer Name

01-01-2021 250 Jarvo

01-02-2021 325 Basha

01-03-2021 475 VK

01-02-2021 530 Jarvo

01-02-2021 607 Basha

01-02-2021 683 VK

01-03-2021 709 Jarvo

01-03-2021 428 Jarvo

We have n no of rows like this we want to add one column at the end for growth percentage that should be compared with current month and previous month.

And then we want to display average growth rate percentage for the last 12 calendar months in top of the dashboard (in card)

Re: Growth percentage calculation for current month using last month cost

rodrigosan — Sat, 11 Sep 2021 02:45:58 GMT

Hello saiprathapdp

I created a file with the proposed solution.
See if it helps.

https://github.com/roolsant/SOSPowerBI/blob/main/Growth_Percentage.zip

Re: Growth percentage calculation for current month using last month cost

saiprathapdp — Sat, 11 Sep 2021 13:40:12 GMT

Hi rodrigosan

we have already table in place with billing date,cost,customer name,etc..,

I just want to calcuate the growth percentage and add as one more column thats all.

If you have any idea about that please share the measures.

Re: Growth percentage calculation for current month using last month cost

rodrigosan — Sat, 11 Sep 2021 14:00:25 GMT

I have already created the measurements in the file!
My intention was to make it as complete as possible for your analysis.

Cost =

SUM(Growth_Percentage[cost ])

Cost Last Month =

IF([Cost]=BLANK(),BLANK(),

CALCULATE(

[Cost],

DATEADD(dimDates[Date],-1,MONTH)))

Difference =

[Cost] - [Cost Last Month]

Percent. =

IF([Cost Last Month] = BLANK(),BLANK(),

DIVIDE([Difference],[Cost]))

YoY =

IFERROR(

[Cost] /

CALCULATE(

[Cost],

SAMEPERIODLASTYEAR(dimDates[Date]))-1,BLANK())