PERCENTILE.INC for each category

[FelipeVaz]

Hi,

Here is an example with my challenge click (onedrive files)

I following cues from
https://powerpivotpro.com/2011/09/creating-accurate-percentile-measures-in-dax-–-part-i/
and ERRATA https://powerpivotpro.com/2012/05/percentile-measures-in-dax-errata/

I am trying to get PERCENTILE.INC not for all values, but for values in each category. Kind difficult to achieve!

There's no PERCENTILE.INC as a function in PowerPivot for Excel 2013. Only 2016!

 

[FelipeVaz]

Hi,

Here is an example with my challenge click (onedrive files)

I following cues from
https://powerpivotpro.com/2011/09/creating-accurate-percentile-measures-in-dax-–-part-i/
and ERRATA https://powerpivotpro.com/2012/05/percentile-measures-in-dax-errata/

I am trying to get PERCENTILE.INC not for all values, but for values in each category. Kind difficult to achieve!

There's no PERCENTILE.INC as a function in PowerPivot for Excel 2013. Only 2016!

ouchhhh, I did it! see the answer below

https://powerpivotpro.com/2011/10/creating-accurate-percentile-measures-in-dax-part-ii/