Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


VBA Blog: 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?


Power BI Tips: 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.


Power BI Tips: Excel-sior Part 3

1 March 2018

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


Power Query: Passing (Reference to) Excel Parameters

28 February 2018

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


Power Pivot Principles: Creating Relationships

27 February 2018

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


Newsletter