Compare values from same column

[etwa702]

Hi chaps

Done some reading on similar threads but not finding the right solution for my need, so posting a new thread.

data model, see link 

Test Details column contains the results from 2 test runs (but there are more in a similar format), one from 15/08/2019_14:38 and another from 15/08/2019_17:17

The Transaction name contains 68 unique page tests where the average response time is captured in Average response time column.

What I’m looking to do is build in a method to add a new column for every transaction name value, that will list the difference between the results and output a value of "higher" or "lower" if the most recent test run is higher or lower than the one it is being compare to. I was hoping the use the Matrix visual for this because I am able to list comparisons of transaction name by short test detail with values of average response time.

https://docs.google.com/spreadsheets/d/1abKdNcVWUgEMOUYwPAxlxm2dX87XdEFZkBBcNy-k5wA/edit#gid=0

[v-piga-msft]

Hi @etwa702 ,

I'm a little confused about your desired output based on your data sample.

---

I was hoping the use the Matrix visual for this because I am able to list comparisons of transaction name by short test detail with values of average response time.

---

If it is convenient, could describe your logic in details and share your desired output so that we could help further on it?

Best  Regards,

Cherry

[etwa702]

@v-piga-msft  I described (i hope) my situation a little better in terms of what I want to achieve in my earlier post.

Any chance to help me out, I'm bashing my head over here!

Thanks.

[etwa702]

hey there, thanks for the response.

See below an example and my powerbi report.

report sample

[etwa702]

just a bump on this question please guys. 

Thanks!

---

@etwa702 wrote:

hey there, thanks for the response.

See below an example and my powerbi report.

report sample

---