percentage of difference between values in power bi

[Anonymous]

how calculate percentage of difference between values in power bi using this formula?

% diff =(new_value-old_value)/old_value 

[Anonymous · Accepted solution]

Hi @Anonymous 

You can get the diff between two values(conventional value) with a measure .

diff = SELECTEDVALUE('Table'[Current Values])-SELECTEDVALUE('Table'[Previous Values])

Then use DIVIDE dax to create a measure like this:

percentage = DIVIDE([diff],SELECTEDVALUE('Table'[Previous Values]))

The effect is as shown :

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dkaushik]

Hi @Anonymous ,

Try creating a measure like this:
%Diff = var NewValue = sum('Table"[NewValue])

             var OldValue = sum('Table'[OldValue])

return
DIVIDE([NewValue]-[OldValue], [OldValue])

Thanks,

Dheeraj

If this post helps, then please consider Accept it as the solution and give thumbs up to help the other members find it more quickly.

[amitchandak]

@Anonymous , You need to have an index column for this.

Please add one in power query and try like if average rate is a column

diff =
var _1 = maxx(filter(Table, [index] =earlier([index])-1),[Avg Rate])
return
divide([Avg Rate] -_1,_1)

[Anonymous]

getting error like this....