Calculate Median for values in a row

[gp_ms]

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!

[ankitpatira]

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