% Difference between columns

[AN_PBI]

Hi All,

I'm trying to get % Difference between columns as sample below. Tried different methods but getting wrong results.

Col A	Col B	Col C	Difference
Jul	95%	99%	4%
Aug	97%	90%	-7%
Sept	80%	100%	20%

Please suggest a way for getting the correct results. Thanks for checking.

[Tahreem24 · Accepted solution]

@AN_PBI ,

I am attaching screen shot and PBIX file with expected output.

[amitchandak]

@AN_PBI , If these are columns

Difference = [Col C] - [Col B]

If B and C are % column Mark Difference also a Percent column

if they are a measure

Difference = [Col C] - [Col B]// All are meausres