On the final Friday of each month, we’re going to set an Excel challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only!

We’re taking a break from the Power BI JSON series to have a quick overview of some of the tools in Power BI that you might have overlooked in your rush to create dashboards and reports. Here are some of the features we think that are worth a special mention:

Welcome to our Power Query blog. This week I look at some useful ways to manipulate dates in M.

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

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

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).