Forum Discussion
Calculate Percentage Change/Difference Between Two Numbers With Formula
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])
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])
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])