Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Community,
I am currently struggling with the calculation of the median in a table. This table contains 10 columns, each with a measure containing a time value in seconds. I would like to calculate the median over the individual measures.
Basically I want something like this:
MedianAllMeasures =
MEDIANX(
'_Measures',
[Part 1] + [Part 2] + [Part 3] + [Part 4] + [Part 5] + [Part 6] + [Part 7] + [Part 8] + [Part 9] + [Part 10].
However, this approach does not work.
I ask for your help. Thank you very much.
Below is a screenshot of the data.
Solved! Go to Solution.
pls try this
MedianAllMeasures =
VAR _tbl ={
[Part 1] , [Part 2] , [Part 3] ,
[Part 4] , [Part 5] , [Part 6] ,
[Part 7] , [Part 8], [Part 9] ,
[Part 10]
}
RETURN
MEDIANX( _tbl,[VALUE])
pls try this
MedianAllMeasures =
VAR _tbl ={
[Part 1] , [Part 2] , [Part 3] ,
[Part 4] , [Part 5] , [Part 6] ,
[Part 7] , [Part 8], [Part 9] ,
[Part 10]
}
RETURN
MEDIANX( _tbl,[VALUE])
Hello Ahmedx,
It worked for me, thank you so much.
Kind regards
Lukas
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |