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
shellacademic
Frequent Visitor

DAX to show number difference between value and the median?

I have a table of:

 

BuildId, BuildDefinitionId, DurationInSeconds

 

I want to see: 

 

BuildId,BuildDefinitionId, MedianDurationByBuildDefinitionId, DifferenceFromMedian

 

So in English, I want to see a report of Builds showing the duration of each build and how much that is different from the median for each BuildDefinition (in seconds).

 

Should this be done in DAX or in a Query? I'm thinking DAX, but I'm not sure the best way. Many thanks.

1 REPLY 1
v-caliao-msft
Employee
Employee

@shellacademic,

 

So in English, I want to see a report of Builds showing the duration of each build and how much that is different from the median for each BuildDefinition (in seconds).

Are there any relationships between BuildId and BuildDerfinitionID? If you could provide us some sample data, we can make further analysis.

 

Regards,

Charlie Liao

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.