Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
@Anonymousin case I understood what you meant then if you use the measure that @SanketBhagwat 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.
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 @SanketBhagwat . 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |