Please note javascript is required for full website functionality.

Blog

Power Query: Moving Date

14 March 2018

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


Power Pivot Principles: A Design for Life

13 March 2018

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


A to Z of Excel Functions: The CUBERANKEDMEMBER Function

12 March 2018

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


VBA Blogs: Getting Loopy Each Time

9 March 2018

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?


A to Z of Excel Functions: The CUBEMEMBERPROPERTY Function

9 March 2018

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


Power BI Blog: Text isn't Limiting! - Part 1

8 March 2018

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


Power Query: Sorry, Not on the List

7 March 2018

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


Power Pivot Principles: Menu Options

6 March 2018

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


A to Z of Excel Functions: The CUBEMEMBER Function

5 March 2018

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


A to Z of Excel Functions: The CUBEKPIMEMBER Function

2 March 2018

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


Newsletter