Forum Discussion
bourne2000
Helper V
4 years agoFinding Median between two columns
Hi I have a two column called min and max Min Max 492 499 500 550 470 480 520 560 490 530 I want to calculate the median between min and max and store into sepe...
- 4 years ago
bourne2000
You can create a measure as follows and add it to a table visual.Median = MEDIANX( {MAX(Table2[Min]) , MEDIAN(Table2[MAX])} , [Value])
Fowmy
Super User
4 years agobourne2000
You can create a measure as follows and add it to a table visual.
Median = MEDIANX( {MAX(Table2[Min]) , MEDIAN(Table2[MAX])} , [Value])