Difference of Averages of the Same Column

[emmawdmi22]

Here is a table I currently have. The values are an average value from lots of data with varying timestamps along with a deviceId. The deviceId is joined to another table which provides the number 1-7 and the type (the column headers).

Next to the column headers, I want another column that has the delta value (like Avg Air Intake 1 - Avg Defi Roller 1).

Thanks in advance for the help! I'm probably just overthinking this and can't figure it out

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.