Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
@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.
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.