Median and Percentiles of a measure over time

[Anonymous]

Hi everyone,

I have a calculated measure which is essentially the average of 3 other sum measures:

Average = (a + b + c)/3, and I plot this measure over time (the data is monthly from 2000-2022).

What I am trying to do now is to calculate the median and specific percentiles (eg. 0.95 or 0.05) of this average measure over time. So for example if we have the below table, be able to calculate the median of all values for all this time period and then plot it as a static line in a chart alongside the average measure above. Essentially, the average will flactuate over time while the median or percentile lines will stay the same over time.

Average	Date
5.7	01/2000
7.9	02/2000
6.7	03/2000
2.5	04/2000
...	...
3.3	02/2022

Looking forward to your replies.

[v-stephen-msft]

Hi @Anonymous ,

You could try the MEDIANX function and the PERCENTILEX.INC function.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You cannot measure a measure.  You need to create new, independent measures that cover the business issue.

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523