Forum Discussion
What DAX function to use to show quartiles
Hi Anonymous
You refer to the following function.
1.PERCENTILE.EXC(<column>, <k>)
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.EXC function (DAX) - DAX | Microsoft Learn
2.PERCENTILE.INC(<column>, <k>)
Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
PERCENTILE.INC function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
You refer to the following function.
1.PERCENTILE.EXC(<column>, <k>)
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.EXC function (DAX) - DAX | Microsoft Learn
2.PERCENTILE.INC(<column>, <k>)
Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
PERCENTILE.INC function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How do you apply this dynamically to a measure not a column?
- Did you ever figure this one out? I am trying to do the same thing
