calculate percentage growth

[Anonymous]

Hi, I want to calculate percentage growth for each row and also for the total. I added a calculated column but then its showing infinity in many rows and even in the total. I manually calculated the % growth in the total and it's -9%. Please help.

[mwegener · Accepted solution]

Hi @Anonymous ,

the measure should look like this, depending on if you are working with columns or measures.

YTD Groth % = DIVIDE(SUM('Table'[YTD Pr Yr Chg]);SUM('Table'[YTD Y-1]))

or

YTD Groth % = DIVIDE([YTD Pr Yr Chg];[YTD Y-1])

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

Thank you @mwegener 

[mwegener]

Hi @Anonymous ,

create a measure.

% cannot be summarized to a total

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.