I ingest data from the Dynatrace API in relation to the drive utilisation of servers. In order to get it to a readable state, I had to Unpivot columns as it was presented like this when it came through:
| Computer | RESULTS.DATE.0 | RESULTS.DATE.1 | RESULTS.DATE.2 | xxxxx | RESULTS.VALUE.0 | RESULTS.VALUE.1 | xxx |
| COMP-4573 | 12/12/2023 | 13/12/2023 | 14/12/2023 | xxxx | 54638 | 5699 | xxxx |
| xxxx | xxxx | xxx | xxxx | xxx | xxxx | xxxx | xxxx |
The RESULTS.DATE (they were in EPOCH Time but did some transformations to get it to a friendly date) columns would repeat for at least 30 times and so would the RESULTS.VALUE column. They both were Unpivoted to combine the two categories together. So now the Date and Results column are in one belonging to their respective category.
The issue I am having is that there is a lot of duplicate dates for the same 'Computer' but the Results column is different too. So it looks like this
| Computer | RESULTS.DATE | RESULTS.VALUE |
| COMP-4573 | 12/12/2023 | 58.1 |
| COMP-4573 | 12/12/2023 | 58.12 |
| COMP-4573 | 12/12/2023 | 58.5 |
| COMP-4573 | 12/12/2023 | 57.8 |
| COMP-4573 | 13/12/2023 | 60 |
| COMP-4573 | 13/12/2023 | 61.2 |
| COMP-4573 | 13/12/2023 | 61.2 |
| xxx | xxxxx | 61.3 |
If I put the visualisation as a table, it is apparent the results value is different and there is variation
Is there a sort of measure or DAX expression which collates the date as one value with the results value? Or to only take in one value from the date column?
