Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gp_ms
Employee
Employee

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
ankitpatira
Community Champion
Community Champion

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

 

 

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.