Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


A to Z of Excel Functions: the LOGINV Function

3 December 2021

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


Power BI Blog: New Format Pane

2 December 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the new Format pane in Preview.


Newsletter