Calculate Percentage Change/Difference Between Two Numbers With Formula

[Anonymous]

How To Calculate Percentage Change Or Difference Between Two Numbers In power bi?

The formula =(new_value-old_value)/old_value

[Anonymous]

Hello @Anonymous ,

You have to create two index columns in Power Query, sort the data first. An index starting from 0 and an index starting from 1. Then in a formula, you have to use the EARLIER function to perform the calculation in a calculated column.

Perecnt Change = (CALCULATE(SUM('Vendor (2)'[Number]),FILTER('Vendor (2)','Vendor (2)'[Index]=EARLIER('Vendor (2)'[Index.1])))-'Vendor (2)'[Number])/'Vendor (2)'[Number]

[Anonymous]

Please replace with a higher quality image of screenshot.

[amitchandak]

@Anonymous , You need add an index column in power query https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

and then add new column in dax

new column =
var _max = minx(filter(Table, [Index] >earlier([Index])), [Index])
var _value = minx(filter(Table, [Index] =_max), [Number])
return
divide(_value-[Number],[Number])

[amitchandak · Accepted solution]

@Anonymous , OR

new column =
var _max = maxx(filter(Table, [Index] <earlier([Index])), [Index])
var _value = minx(filter(Table, [Index] =_max), [Number])
return
divide([Number]-_value,_value)
//or use divide(_value-[Number],[Number])