calculated field on same table and field

[MG4]

Hi all,

On "X" table I have two (relevant) fields: "weeks" and "volume".

I want to display 3 columns: the volume on current week , the volume on the previous week and the difference between these two weeks (Delta).

I have tried to do so but I don't know how to calculate the delta between two columns that actually belong to the same field.

Thanks in advanced!

[Anonymous · Accepted solution]

@MG4,

Create the following columns in your table. If the DAX don't help, please share dummy data of your table and post expected result.

pre = CALCULATE(FIRSTNONBLANK(X[Volume],1),FILTER(X,X[Weeks]=EARLIER(X[Weeks])-1))

delta = IF(ISBLANK(X[pre]),BLANK(), X[Volume]-X[pre])

Regards,
Lydia