Welcome back to the Power Pivot Principles blog. This week, we will talk about using the SWITCH function to return an Expression.

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem 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 / Power BI 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 are no prizes at this stage: you’re playing for bragging rights only!

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to calculate cumulative totals for time periods in Power BI.

Welcome to our Power Query blog. This week, I look at unpivoting data with multiple headings.

Welcome back to the Power Pivot Principles blog. This week, we will look at an alternative way to calculate the All Year Sales in our seemingly never-ending case study.

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

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to talk about the dashboard design.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to create a card that displays slicer selections in Power BI.

Welcome to our Power Query blog. This week, I look at how to use M metadata functions to create a ToolTip for columns.