Welcome back to the Power Pivot Principles blog. This week, we are going to introduce a method to extract a single value from the group text columns.

Welcome back to the Power Pivot Principles blog. This week, we are going to look at the function SAMEPERIODLASTYEAR function.

Welcome back to the Power Pivot Principles blog. This week, we are going to provide a refresher regarding creating a calendar table.

Welcome back to the Power Pivot Principles blog. This week, we are going to look at the SUMMARIZE function.

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.