Difference between columns with a mesure

[mtrevisiol]

Hi everyone,

I've got a table with four columns: ID, Min, Value and Max (they represent some values recorded by a production machine):

My intention is to create two measures:

- the first one would be the difference between Max and Val

- the second is the difference between Val and Min

and they are calculated for each row of the table

How can I create them? Thank you!

[amitchandak · Accepted solution]

@mtrevisiol , new measure can be like

M1= Sumx(Table, Table[Max] -Table[Min])

M2= Sumx(Table, Table[value] -Table[Min])

[mtrevisiol]

Many thanks @amitchandak !