Please note javascript is required for full website functionality.

Blog

Power Query: Pivot Problems

13 January 2021

Welcome to our Power Query blog. This week, I look at an example using a pivot.


Power Pivot Principles: Slicers for Columns – Part 1

12 January 2021

Welcome back to the Power Pivot Principles blog. This week, we will talk about creating slicers for columns.


Charts and Dashboards: Working Capital Adjustment Chart

8 January 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will illustrate how to create a Working Capital Adjustment chart.


Power BI Blog: New Year, New Icons

7 January 2021

Welcome back to this week’s edition of the Power BI blog series. This week,we look at the new field lists and icons (currently in Preview mode) in Power BI.


Power Query: New Year Function

6 January 2021

Welcome to our Power Query blog. This week, I look at an example using custom functions.


Power Pivot Principles: SWITCH the Slicer

5 January 2021

Welcome back to the Power Pivot Principles blog. This week, we will discuss about using slicers with the SWITCH function.


A to Z of Excel Functions: The IMSQRT Function

4 January 2021

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


Charts and Dashboards: Dynamic Simulation Charts

1 January 2021

Happy New Year! Welcome back to this week’s Charts and Dashboards blog series. As the first blog of the year, we will create a dynamic simulation chart.


Power BI Blog: Anomaly Detection

31 December 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at one of Power BI’s new features: Anomaly Detection.


Power Query: Timings

30 December 2020

Welcome to our Power Query blog. This week, I look at an example where I need to sum time.


Newsletter