Forum Discussion

mtrevisiol's avatar
mtrevisiol
Helper V
5 years ago
Solved

Difference between columns with a mesure

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!

  • mtrevisiol , new measure can be like

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

     

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