Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |