How to calculate %-change to previous row with partition by (grouping)

[hony]

Hi there,

I have to use DAX to do this:

For Each Group of Material (first column) I want to calculate the difference of the price compared to previous row. 

I tried to find a solution that is there but only found ways to do it without the partition of material (first column).

Thanks a lot

[amitchandak]

@hony , Try a new column like

New column =
var _max = maxx(filter(Table, [Material] = earlier([Material]) && [Date_eop] < earlier([Date_eop])), [Date_eop])
var _price =maxx(filter(Table, [Material] = earlier([Material]) && [Date_eop] < =_max), [price])
return
divide([price] -_price,_price)