Welcome back to our Power Pivot blog. Today, we discuss how to use a combination of disconnected tables and variables to produce unique slicers in Power BI.

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.

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!

This week, we’re going to divert a little bit away from Power BI directly, and talk about how it can integrate into Microsoft Teams. This is the central part of what Tim’s presentation in Singapore last week was all about. We’ll spread this over the next few weeks. This first week, we’re just going to introduce what Microsoft Teams is, and how it can interface with Power BI.

Welcome to our Power Query blog. This week, I look at extracting a number from a mixed column.

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

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

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

This week, there are no new tips and tricks, but that’s because we’re presenting at Microsoft Ignite – The Tour over in Singapore!

Welcome to our Power Query blog. This week, I look at a neat way of linking tables with similar key data.