Microsoft Power BI ‚PERCENTILE.EXC‘ – returns the k-th percentile of values in a range where k is in the range 0..1 exclusive

PERCENTILEX.EXC Funktion – how to return the percentile number of an expression evaluated for each row in a table

 

PERCENTILE.EXC(<column>, <k>)

Example … how to calculate the 80th percentile

_Percentil80 = PERCENTILE.EXC(x9153pfc[TIME], 0.8)

This entry was posted on Samstag, November 11th, 2023 at 13:04 and is filed under Administration, Power BI. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.