Welcome back to the Power Pivot Principles blog. This week, we explain the advantages of creating measures from fields. Who’d have thought..?

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.

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

On the final Friday of each month, we are 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 are playing for bragging rights only!

We thought we would bring you some news hot off the press this week. Microsoft has recently announced the initial availability of a connected PivotTable refresh in Excel for the web. This new capability makes it easier for organisations to share data and collaborate using Power BI and Excel. You can now explore, and refresh PivotTables connected to Power BI inside Excel for the web, and easily share these workbooks through OneDrive and SharePoint.

Welcome to our Power Query blog. This week, I look at how Power BI Desktop uses query folding in the Power Query engine.

Welcome back to the Power Pivot Principles blog. This week, we are going calculate Cost of Goods Sold and cash payments for Cost of Goods Sold.

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

Welcome back to this week’s Charts and Dashboards blog series. Over the next two weeks, we will discuss creating a bar chart with dynamic ordering.

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at improving the measure that compares the previous month’s collection values with the current month’s collection values.