Power BI
Under ReviewAdd Median & Percentile.EXC to the Aggregate Functions in Report Builder/SSRS
on 22 Jun 2017 19:41:38
From the various blogs and websites I've read over the years being able to calculate a Median and Percentile in Report Builder has been a longstanding issue with attempts to do so through code resulting in glitchy results at best, particularly if you're trying to do so and have several different Row Groups and Column Groups. Couldn't Median and Percentile.EXC Aggregate Functions just be added to Reort Builder so it's a simple to calculate as it currently is to calculate the Average? It seems kind of silly that this hasn't been done after all these years.
Administrator on 22 Jul 2017 08:17:35
Thanks for the feedback! Others, chime in with your votes and comments here.
- Comments (2)
RE: Add Median & Percentile.EXC to the Aggregate Functions in Report Builder/SSRS
Our CEO wants to see Medians along with averages in both paginated and Power BI reports. Add in a function or additional SQL to hundreds of reports is not really an option. It's tought to tell the CEO no. Please add a median calculation.
RE: Add Median & Percentile.EXC to the Aggregate Functions in Report Builder/SSRS
Median is a percentile calculation. I helped someone do this just a week ago for a report based on SQL Server data.
Since SQL Server 2012, the median calculation can be written like this in T-SQL (depending whether you want continuous or discrete):
SELECT PERCENTILE_CONT(0.5) WITHIN GROUP(ORDER BY ) OVER () as Median
It would be good not to have to keep calculating it this way.