Can we use more than one criteria with the CALCULATE function?

Welcome back to our Power Pivot blog series. Today we discuss a function that we can use in developing measures.

After importing data into Power Pivot, we may wish to create a PivotTable.

How to include error traps in our measure formulae.

Today we discuss proper practices we should adopt when creating measures.

Welcome back to our Power Pivot blog series. Today we discuss how to tell the difference between a measure and a field.

Today we talk about measures.

Welcome back to our Power Pivot blog. Today, we consider how to create a calculated column.

Today let’s go over the syntax between a table, a field, and a measure.

To conclude our series covering menu tabs, we will cover the Power Pivot menu options in Excel.