Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to get together testing results for multiple environments.
+----------+--------------+------------+
| TEST | Result env A | Date |
+----------+--------------+------------+
| test 1 | 10 | 2018-07-01 |
| test 1 | 15 | 2018-07-02 |
| test 2 | orange | 2018-07-03 |
+----------+--------------+------------+
+----------+--------------+------------+
| TEST | Result env B | Date |
+----------+--------------+------------+
| test 1 | -10 | 2018-07-01 |
| test 1 | -20 | 2018-07-02 |
| test 2 | monday | 2018-07-01 |
+----------+--------------+------------+
OUTPUT should be someting like this (only taking most actual result)
+----------+--------------+--------------------+
| TEST | Result env A | Result env B |
+----------+--------------+--------------------+
| test 1 | 15 | -20 |
| test 2 | orange | monday |
+----------+--------------+--------------------+
when I was working with one table I use calculated columns
https://stackoverflow.com/questions/51437962/select-row-with-max-value-per-category-power-bi to get max date and work with that
But I dont know how to put these tables together, I was trying relationships between tables (adding some table to have relationship 1:N), was trying to merge tables but no luck.
Any tip how to process it ?
Thanks
Solved! Go to Solution.
Hi @murdoc ,
What do you mean "only taking most actual result" when generating the desired output? Please provide more description about your requirement. How to calculate result? How to establish relationship? What should be considered to filter records?
Regards,
Yuliana Gu
sorry I guess my description was little confusing
I have multiple tables (each for some environment) which are being constantly updated with the new test result and time stamp.
My desired output would be to connect these tables but only take for each test case (group by TEST) most recent result ( highest timestamp / date )
so in the output table will TEST 1 with one column representing result with biggest date, another column representing second table for TEST 1 with max date
nevermind i solve it on source side of the data
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |