Forum Discussion

bourne2000's avatar
bourne2000
Helper V
4 years ago
Solved

Finding Median between two columns

Hi

 

I have a two column called min and max

 

MinMax
492499
500550
470480
520560
490530

 

I want to calculate the median between min and max and store into seperate column called 'median

 

 

expected result

 

MinMaxMedian
492499495.5
500550525
470480475
520560540
490530510

 

I calculated the median in excel, not sure how to do in Power BI?

 

Can anyone advise?

 

 

Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    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])

     



1 Reply

  • Fowmy's avatar
    Fowmy
    Super User
    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])