Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
etwa702
Frequent Visitor

Compare values from same column

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

4 REPLIES 4
v-piga-msft
Resident Rockstar
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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.

hey there, thanks for the response.

See below an example and my powerbi report.

report sample

 

BI Report.png

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

 

BI Report.png


 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.