Forum Discussion
DAX Query
Hi ..I am new to DAX ... Pls help me.... I have to get the difference of values based on two entries of the same column & time. How can I get the difference of Telemetry values of SensorID 975425 & ...
Okay, then you can modify your measure a bit;
Difference=CALCULATE(SUM(Table[Telemetry]),Table[SensorID]="975425") - CALCULATE(SUM(Table[Telemetry]),Table[SensorID]="975424").
Let me know if that helps.
Hi Thank you for your response. But I have only one table , where the SensorID field contains the values based on which I have to do the comparison.
Okay, then you can modify your measure a bit;
Difference=CALCULATE(SUM(Table[Telemetry]),Table[SensorID]="975425") - CALCULATE(SUM(Table[Telemetry]),Table[SensorID]="975424").
Let me know if that helps.
Thank you Anonymous . This gives me the sum of value difference. I need to get the row wise difference as in figure 1 ,ie. 370.14-252.15=?, for each row.