PERCENTILE_CONT is used for calculating a percentile based on a continuous distribution of the column value. From ORACLE SQL documentation:The result of PERCENTILE_CONT is computed by linear interpolation between values after ordering them. Using the percentilevalue (P) and the number of rows…
T-SQL to DAX: Simulating CUME_DIST analytic function
CUME_DIST() analytical function was introduced in SQL 2012 for calculating the cumulative distribution of a value in a group of values.Its calculated as number of rows with value equal to or less than current value divided by total rows for…
T-SQL to DAX : Simulating PERCENT_RANK() analytic function
Recently I was involved in a project which required rewriting few logic from T-SQL using DAX functions for migrating values to a Power pivot based model. The DAX function set being not as comprehensive as T-SQL required me to simulate…
T-SQL to DAX: Simulating RANK function
RANK() function helps us to find out rank of a row based on particular sequence within a sql table or data group within it. DAX doesn’t have a corresponding function available within it to get the RANK. This blog post…