Please note javascript is required for full website functionality.
MVP

Blog

Blog

A to Z of Excel Functions: the INDIRECT Function

22 February 2021

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


Charts and Dashboards Blog: Bullet Charts – Part 2

19 February 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we continue our review of Bullet Charts.


Power BI Blog: Dynamic Headings for In-Between Variables

18 February 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we’ll discuss another approach to dynamic headings, this time for variables between two periods using a time slicer selection.


Power Query: Don’t Miss Out

17 February 2021

Welcome to our Power Query blog. This week, I look at the Excel.Workbook() M function


Power Pivot Principles: Amendments Made Easily

16 February 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll continue last week’s example, which we are going to turn into a large case study over the next few weeks.


A to Z of Excel Functions: the INDEX Function

15 February 2021

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


Charts and Dashboards Blog: Bullet Charts – Part 1

12 February 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we begin a review of Bullet Charts.


Power BI Blog: Easier Dynamic Heading Based on Time Slicer

11 February 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will discuss about an easier approach to dynamic heading based on time slicer selection.


Power Query: All Over Running Totals

10 February 2021

Welcome to our Power Query blog. This week, I return to the running totals example from last week, to apply a more complex solution.


Power Pivot Principles: Calculating Measures

9 February 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll examine an example of how to convert a field to a measure.


Newsletter