Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Implement PERCENTILE_DISC in DAX

SQL's PERCENTILE_DISC function returns a value from a dataset (see https://docs.microsoft.com/en-us/sql/t-sql/functions/percentile-disc-transact-sql), but doesn't seem to have an equivalent in DAX. DAX's PERCENTILE.INC *seems* to return the same result as SQL's PERCENTILE_CONT, but DAX's PERCENTILE.EXC doesn't return the same result as SQL's PERCENTILE_DISC. My team seems to prefer the result of PERCENTILE_DISC over PERCENTILE_CONT, hence my request...
Status: Needs Votes
Comments
fbcideas_migusr
New Member
Status changed to: Needs Votes