Please note javascript is required for full website functionality.
MVP

Blog

Blog

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...


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.


A to Z of Excel Functions: the ISFORMULA Function

24 May 2021

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


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

21 May 2021

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.


Power BI Blog: Calculating Monthly % Change Update

20 May 2021

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


Power Query: Folding Table

19 May 2021

Welcome to our Power Query blog. This week, I look at Query Folding.


Power Pivot Principles: PREVIOUSQUARTER Comparison

18 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare quarterly data using a new Power Pivot function.


A to Z of Excel Functions: the ISEVEN Function

17 May 2021

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


Charts and Dashboards Blog: Chart Titles as a Text Box

14 May 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will talk about creating a chart title using a text box.


Newsletter