Adding Value for the Times
9 March 2018
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CUBEMEMBERPROPERTY 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?
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.
7 March 2018
This week, I take a look at how extracting data from multiple lists can be confusing when nulls are involved.
6 March 2018
Today we consider some of the various menu options in the Power Pivot window...
5 March 2018
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CUBEMEMBER function.
2 March 2018
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CUBEKPIMEMBER function.
1 March 2018
Welcome to Power BI Tips. Following on from last week, creating our first visualization, a clustered column chart
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.
27 February 2018
Today we discuss what are relationships (in Power Pivot) and how we may create them...
Page 9 of 41.
Sign up to receive our newsletter
SumProduct are experts in Excel Training. Providing Financial Modelling, Strategic Data Modelling, Model Auditing, Planning & Strategy and Training Courses.