How to calculate business days between dates in DAX: step by step
How to calculate business days between dates in DAX and exclude weekends and holidays, with an example measure and holi…
3 min
12 Sep 2026
How to calculate business days between dates in DAX and exclude weekends and holidays, with an example measure and holi…
How to calculate a weighted moving average in DAX to smooth time series. Practical example with measures, date filterin…
Learn how to calculate cohort retention rate in DAX to analyze user retention over time. Practical example and common m…
How to create percentile (P90) in DAX and apply filters: practical example to calculate P90 of times or values using ME…
How to calculate average resolution time in DAX: learn to create measures that compute the average difference between t…
How to calculate weighted average by group in DAX and obtain a correct value per category using measures, FILTER and SU…
Monthly churn in DAX: learn how to calculate the rate of customers lost per month using PREVIOUSMONTH, EXCEPT and DIVID…
Learn how to use the RELATED function in DAX to pull values from a related table into another, with a practical sales-a…
Learn how to calculate the percentage of total in DAX using DIVIDE, CALCULATE and ALL. A step-by-step guide with exampl…
Learn how to use the SWITCH function in DAX step by step: map values, build tiers with SWITCH(TRUE()) and replace neste…
Learn how to use the DIVIDE function in DAX to calculate ratios without division-by-zero errors, with a practical margi…
Learn how to build a dynamic ranking with the RANKX function in DAX. A step-by-step example in Power BI, covering ALL, …
This site uses essential cookies and, with your consent, statistics cookies (Google Analytics) to improve your experience. Cookie Policy