Forum Discussion

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper V
4 years ago
Solved

Finding 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...
  • Fowmy's avatar
    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])