cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gp_ms Visitor
Visitor

Calculate Median for values in a row

Hello,

 

I am completely new to DAX, and PowerBI, and this must be very easy to do, but I must be missing some basic knowledge.

 

I have a Table in following format

 

                   SomeData MoreData Day1Count Day2Count Day3Count..... 

Device1

Device2

Device3

 ...

 

I would like to add a new column that for each Device calculates the Median value for Day1Count, Day2Count, Day3Count... values. What Can I pass as argument to MedianX?

 

Thanks!

1 REPLY 1
Super User
Super User

Re: Calculate Median for values in a row

@gp_ms In power bi desktop query editor, hightlight all count columns and calculate Median as shown below.

 

 

Capture.PNG