Adding Value for the Times
18 June 2018
This function converts a decimal number (base 10) to hexadecimal (base 16).
15 June 2018
It’s easy enough to get on a cell’s case as we explored last week, but what if we wanted to find a cell that is formatted in a particular way?
14 June 2018
Using the Power Query editor to determine unique combinations from the NY Powerball data.
13 June 2018
Welcome to our Power Query blog. Following on from last week’s blog, this time I look at some useful transforming Text() functions in M.
12 June 2018
Welcome back to our Power Pivot blog. Today we discuss how to use the ALL function in DAX.
11 June 2018
This function converts a decimal number (base 10) to binary (base two).
8 June 2018
Last week we used the LookAt parameter with the Find method to match the complete word. This week we look at case.
7 June 2018
Welcome back to Power BI Tips! This week, we begin Just Speculating Over the NY Powerball numbers.
6 June 2018
Welcome to our Power Query blog. This week, I look at some useful Boolean Text() functions in M.
5 June 2018
Welcome back to our Power Pivot blog. Today we discuss negating formulas in Power Pivot.
Page 1 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.