Last week we looked at For Each…Next loops – but this time let’s have a look at While Wend loops.

Welcome back to Power BI Tips! Continuing with the US Census Historical Population Estimates text file exercise.

This week, I look at how to transform extracted data into a useful table.

oday, we consider some of the menu options in the Power Pivot window, focusing on the Design tab.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CUBERANKEDMEMBER function.

Loops are a powerful tool in programming to repeat a sequence of instructions. But what if you want to perform an action to every object in a set?

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CUBEMEMBERPROPERTY function.

Welcome back to Power BI Tips! Looking at a new exercise with importing and massaging data from a text file from the US Census.

This week, I take a look at how extracting data from multiple lists can be confusing when nulls are involved.

Today we consider some of the various menu options in the Power Pivot window...