Welcome back to the Power Pivot Principles blog. This week, we are going to learn a new function, HASONEVALUE.

Welcome back to our Power Pivot blog. Today, we look at the ISFILTERED function.

Welcome back to our Power Pivot blog. Today, we look at the SUBSTITUTE function.

Welcome back to our Power Pivot blog. Today, we look at the REPLACE function.

Welcome back to our Power Pivot blog. Today, we look at an alternative method of calculating cumulative sums without using the EARLIER function.

Welcome back to our Power Pivot blog. Today, we look at another application of the EARLIER function.

Welcome back to our Power Pivot blog. Today, we look at the EARLIER function.

Welcome back to our Power Pivot blog. Today, we look at how to create a PivotChart that highlights the number of absent students in university classes.

Welcome back to our Power Pivot blog. Today, we expand on the rolling average concept, first introduced in a previous blog, and show you how to include a dynamic period selection range in a rolling average measure.

Welcome back to our Power Pivot blog. Today, we expand on the rolling average concept first introduced in a previous blog and show you how to include a dynamic selection range to a rolling average measure.