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 & 975424 wrspt to time? TIA
5 Replies
Anonymousin case I understood what you meant then if you use the measure that Anonymous sent you and put dates on the axis of the column you will get the differenct per each row in the table visual.
If you want to also see the values for each Sensor on the table you can also add 2 measures and them also to the table.
975425_Value = CALCULATE(SUM(Table[Telemetry]),Table[SensorID]="975425")
975424_Value = CALCULATE(SUM(Table[Telemetry]),Table[SensorID]="975424")Hi Anonymous .
If dates in both the columns are exact same then I think you can directly calculate the difference between Telemetry columns subject to a active relationship between this 2 tables based on 'Time' Column.
Create a measure as Difference=SUM(Table1[Telemetry])-SUM(Table2[Telemetry])
If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.
