Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The LAMBDA Function

17 December 2021

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


Power BI Blog: Pie and Donut Chart Rotation

16 December 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we look at rotating Pie and Donut charts.


Power Query: Riveting Results Part 1

15 December 2021

Welcome to our Power Query blog. This week, I look at an example where I plan to use parameters.


Power Pivot Principles: Generating a List of Measure Descriptions

14 December 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll talk about how to generate a list of measure or column descriptions using DMV queries.


A to Z of Excel Functions: The MAKEARRAY Function

13 December 2021

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


A to Z of Excel Functions: The LOWER Function

10 December 2021

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


Power BI Blog: New Page and Bookmark Navigators

9 December 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we look at two new built-in navigators.


Power Query: Selective Staffing Part 7

8 December 2021

Welcome to our Power Query blog. This week I look at an example that considers values that can be marked as included or excluded.


Power Pivot Principles: The A to Z of DAX Functions – CALENDARAUTO

7 December 2021

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at the CALENDARAUTO function.


A to Z of Excel Functions: The LOOKUP Function

6 December 2021

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


Newsletter