Welcome back to the Power Pivot Principles blog. This week, we will consider where to store measures when you have many measures and tables in your database.

Welcome back to the Power Pivot Principles blog. This week, we will talk about using measures to define target values for KPIs.

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.