PERCENTILE.EXC, PERCENTILE.INC, PERCENTILEX.EXC, PERCENTILEX.INC - DAX Guide

Опубликовано: 15 Октябрь 2024
на канале: SQLBI
11,781
85

PERCENTILE.EXC: Returns the k-th (exclusive) percentile of values in a column.
https://dax.guide/percentile-exc/

PERCENTILE.INC: Returns the k-th (inclusive) percentile of values in a column.
https://dax.guide/percentile-inc/

PERCENTILEX.EXC: Returns the k-th (exclusive) percentile of an expression values in a table.
https://dax.guide/percentilex-exc/

PERCENTILEX.INC: Returns the k-th (inclusive) percentile of an expression values in a table.
https://dax.guide/percentilex-inc/

This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.

How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...
Code, run, and share DAX with DAX.do: https://dax.do/?aff=yt

#dax #powerbi #ssas #tabular #analysisservices #powerpivot