Solved: Re: How to calculate ((B-A) / A) * 100

Anonymous · ‎11-09-2019

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 · ‎11-09-2019

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

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

Proud to be a Super User!

View solution in original post

Nathaniel_C · ‎11-09-2019

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