Welcome to our Power Query blog. This week, I look at some useful logical M functions to determine whether a date is in a particular period.

Welcome back to our Power Pivot blog. Today, we discuss managing multiple tables.

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

More VBA optimisation tricks so you can stop reticulating splines.

Utilising Get Data from an MS Access database in Power BI.

Welcome to our Power Query blog. This week, I look at some ways to determine the end (and the start) of a particular date period in M.

Welcome back to our Power Pivot blog. Today, we discuss how to use filters in Power Pivot.

This function converts a text representation of a number in a given base into a decimal number (base 10).

VBA Blog about improving calculation speeds.

One of the neat things about Power BI is the large number of connectors to Get & Transform data. We’ve been working with flat files until now but to realise the full potential of Power BI, we’re going to start having to work with REAL data.