Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: A Bar Chart with Dynamic Ordering – Part 2

4 June 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to talk about the bar chart with dynamic ordering.


Power BI Blog: Smart Narratives Now Generally Available

3 June 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we look at Smart Narratives, which are now Generally Available in Power BI Desktop.


Power Query: Evasive Errors

2 June 2021

Welcome to our Power Query blog. This week, I look at a problem I came across when uploading a large dataset from Excel.


Power Pivot Principles: Initial Measures – a Pro Tip

1 June 2021

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


Monday Morning Mulling: May 2021 Challenge

31 May 2021

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.


A to Z of Excel Functions: The ISLOGICAL Function

31 May 2021

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


Final Friday Fix: May 2021 Challenge

28 May 2021

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!


Power BI Blog: Share and Collaborate in Excel for the web Connected to Power BI

27 May 2021

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.


Power Query: Intelligent Folding

26 May 2021

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


Power Pivot Principles: COGS and COGS Cash Payments

25 May 2021

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.


Newsletter