Welcome back to the Power Pivot Principles blog. So far, we have discussed only about using measures in Power Pivot. This week, we will move away from measures and talk about Key Performance Indicators (KPIs).

Welcome back to the Power Pivot Principles blog. This week, we will talk about using the AVERAGEX function when working with averages in DAX.

Welcome back to the Power Pivot Principles blog. This week, we will discuss working with averages in DAX.

Welcome back to the Power Pivot Principles blog. This week, we will talk about the REMOVEFILTERS function in DAX.

Welcome back to the Power Pivot Principles blog. This week, we consider how to calculate the percentage of a total using the ALLNOBLANKROW.

Welcome back to the Power Pivot Principles blog. This week, we will talk about the ALLNOBLANKROW in DAX.

Welcome back to the Power Pivot Principles blog. This week, we will talk about using the SWITCH function to return an Expression.

Welcome back to the Power Pivot Principles blog. This week, we will look at an alternative way to calculate the All Year Sales in our seemingly never-ending case study.

Welcome back to the Power Pivot Principles blog. This week, we will be considering the penultimate steps in our irregular month-end reporting case study.

Welcome back to the Power Pivot Principles blog. This week, we still continue with our irregular month-end reporting case study.