Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table of:
BuildId, BuildDefinitionId, DurationInSeconds
I want to see:
BuildId,BuildDefinitionId, MedianDurationByBuildDefinitionId, DifferenceFromMedian
So in English, I want to see a report of Builds showing the duration of each build and how much that is different from the median for each BuildDefinition (in seconds).
Should this be done in DAX or in a Query? I'm thinking DAX, but I'm not sure the best way. Many thanks.
So in English, I want to see a report of Builds showing the duration of each build and how much that is different from the median for each BuildDefinition (in seconds).
Are there any relationships between BuildId and BuildDerfinitionID? If you could provide us some sample data, we can make further analysis.
Regards,
Charlie Liao
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |