Solved: Finding Median between two columns

bourne2000 · ‎10-16-2021

Hi

I have a two column called min and max

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

expected result

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

Can anyone advise?

Fowmy · ‎10-17-2021

@bourne2000

You can create a measure as follows and add it to a table visual.

Median = MEDIANX( {MAX(Table2[Min]) , MEDIAN(Table2[MAX])} , [Value])

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎10-17-2021

@bourne2000

You can create a measure as follows and add it to a table visual.

Median = MEDIANX( {MAX(Table2[Min]) , MEDIAN(Table2[MAX])} , [Value])

Did I answer your question? Mark my post as a solution! and hit thumbs up

Finding Median between two columns