Add Column - Median of columns

[ngct1112]

Hi, I am trying to find out the "Median" from few columns(A,B,C) with this formula.

However, the result is not correct since it could count the Blank as 0. Is there any way I can modify this formula so that it can ignore the Blank? Great thanks!

Median = MEDIANX({[A],[B],[C],[D]}),VALUE([VALUE))

Item	A	B	C	Result - Median
A1	2	4	5	4
A2	6	8	12	8
A3	2	5		2
A4	4	6		4
A5	3	6	7	6

[ngct1112]

@Fowmy It works! Great thanks with your help

[Fowmy · Accepted solution]

@ngct1112 

Add this as a column to your table:

Median = 
VAR T = FILTER({[A],[B],[C]}, [Value]<>BLANK()) RETURN
MEDIANX(T,VALUE([Value]))

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn