topic Re: DAX Query in DAX Commands and Tips

DAX Query

Anonymous — Fri, 17 Jun 2022 08:44:36 GMT

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

SpartaBI

Re: DAX Query

Anonymous — Fri, 17 Jun 2022 06:26:41 GMT

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.

Re: DAX Query

Anonymous — Fri, 17 Jun 2022 06:31:35 GMT

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.

Re: DAX Query

Anonymous — Fri, 17 Jun 2022 06:34:53 GMT

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.

Re: DAX Query

Anonymous — Fri, 17 Jun 2022 06:45:06 GMT

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.

Re: DAX Query

SpartaBI — Fri, 17 Jun 2022 09:02:57 GMT

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")

Showcase Report – Contoso By SpartaBI