Compare data and print the percentage of difference between the two

[verinalobo]

Hello,

I am fairly new to PowerBI and need help with a query for comparison of data for different dates. This is the data I have:

RunID	Date	Transaction	Value
100	01-Aug-23	01_Launch	10
100	01-Aug-23	02_Login	10
100	01-Aug-23	03_Search	9
100	01-Aug-23	04_Order	8
100	01-Aug-23	05_Payment	10
100	01-Aug-23	06_Logout	9
101	02-Aug-23	01_Launch	8
101	02-Aug-23	02_Login	7
101	02-Aug-23	03_Search	7
101	02-Aug-23	04_Order	8
101	02-Aug-23	05_Payment	9
101	02-Aug-23	06_Logout	4
102	05-Aug-23	01_Launch	11
102	05-Aug-23	02_Login	12
102	05-Aug-23	03_Search	11
102	05-Aug-23	04_Order	14
102	05-Aug-23	05_Payment	9
102	05-Aug-23	06_Logout	7
103	10-Aug-23	01_Launch	8
103	10-Aug-23	02_Login	9
103	10-Aug-23	03_Search	7
103	10-Aug-23	04_Order	8
103	10-Aug-23	05_Payment	6
103	10-Aug-23	06_Logout	5

I need a query that will have a table printed with the comparison of two RunIDs or Date (based on the selection made using slicers). The table should look something like the one below. It should show the % of inprovement or degradation for every transaction between runs. (The RunID is always unique). Eg of the formula in excel: D2=(B2-C2) in %

Transaction	Run 100	Run 101	Comparison 100 vs 101
01_Launch	10	8	200%
02_Login	10	7	300%
03_Search	9	7	200%
04_Order	8	8	0%
05_Payment	10	9	100%
06_Logout	9	4	500%

Thanks in advance!

[verinalobo]

Hello, 

A small change to what I am looking for:

The comparison doesn't necessarilty have to be between two RunIDs selected using slicers, but it could just be the latest RunID vs the previous RunID.

Thanks!