One thing a regular coder always has to consider is optimisation. Code optimisation is the process of modifying code to improve quality and efficiency. By looking doing code optimisation, programs can become more lightweight in size, consume less memory, execute more rapidly and perform fewer operations.

Last week we created a data set that hat the lottery combinations by date. What if we wanted to know when they were last drawn?

Welcome to our Power Query blog. Following on from last week’s blog, this week I look at some useful extraction Text() functions in M.

Welcome back to our Power Pivot blog. Today we discuss how to use the ALLEXCEPT function in DAX.

This function converts a decimal number (base 10) to hexadecimal (base 16).

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?

Using the Power Query editor to determine unique combinations from the NY Powerball data.

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.

Welcome back to our Power Pivot blog. Today we discuss how to use the ALL function in DAX.

This function converts a decimal number (base 10) to binary (base two).