Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: The A to Z of DAX Functions – INFO.CULTURES

16 July 2024

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


A to Z of Excel Functions: The RANK.EQ Function

15 July 2024

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


Excel for Mac: PivotTable sorting

12 July 2024

This week in our series about Microsoft Excel for Mac, we cover PivotTable sorting, showing a few differences between Mac and Windows.


Power BI Blog: Power BI Home in Power BI Desktop

11 July 2024

Welcome back to our Power BI blogs. This time, we discuss the new Home screen, now Generally Available to all Power BI Desktop users.


Power Query: Month Mayhem – Part 2

10 July 2024

Welcome to our Power Query blog. Today, I continue looking at how to index my data to keep everything in order.


Power Pivot Principles: The A to Z of DAX Functions – INFO.COLUMNSTORAGES

9 July 2024

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


A to Z of Excel Functions: The RANK.AVG Function

8 July 2024

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


Excel for Mac: no Fuzzy Merge in Power Query? How to ignore case when merging queries.

5 July 2024

This week in our series about Microsoft Excel for Mac, we show you how to merge queries when you have text fields that would be good for a Fuzzy merge in Power Query, even though that feature doesn’t exist on Mac.


Power BI Blog: Power BI Blog: Customising a Threshold Column Chart

4 July 2024

Welcome back to this week’s edition of the Power BI blog series. Last week, we looked at how to create a threshold column chart to highlight columns that rise above a set threshold. This week, we demonstrate some interesting ways you can customise this type of chart.


Power Query: Month Mayhem – Part 1

3 July 2024

Welcome to our Power Query blog. Today, I look at an example where I need to realign some of the data.


Newsletter