Forum Discussion
mtrevisiol
5 years agoHelper V
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])
2 Replies
- amitchandakSuper User
mtrevisiol , new measure can be like
M1= Sumx(Table, Table[Max] -Table[Min])
M2= Sumx(Table, Table[value] -Table[Min])
- mtrevisiolHelper V
Many thanks amitchandak !