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...

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

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

Welcome to Power BI Tips. Following on from last week, creating our first visualization, a clustered column chart

Welcome to our Power Query blog. This week, I take a look at how to pass Excel data as a parameter in Power Query.

Today we discuss what are relationships (in Power Pivot) and how we may create them...

Last week, we asked how you could set up a cell to pick up text from parts of an Excel spreadsheet, and present it in a ready-for-email form.

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