How to calculate ((B-A) / A) * 100

[Anonymous]

Hi,

great honor to be a part of this community.. How can I create a calculated column for this ((B-A) / A) * 100 with DAX?

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,
In Power BI go to Modeling tab, New Column and see the formula in the top picture. In Power Query, go to Add Column tab, Custom Column, and insert the formula in the bottom picture.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel 

[Nathaniel_C]

My apologies, used a divide by b rather than a. Just switch those.