cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bourne2000
Helper III
Helper III

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?

 

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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_0-1634460334283.png

 



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


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

1 REPLY 1
Fowmy
Super User
Super User

@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_0-1634460334283.png

 



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


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.