Please note javascript is required for full website functionality.

Blog

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

4 June 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.CALCULATIONITEMS.


Monday Morning Mulling: May 2024 Challenge

3 June 2024

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Final Friday Fix: May 2024 Challenge

31 May 2024

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Power BI Blog: The Duo Chart – Part 1

30 May 2024

Welcome back to our Power BI blogs. This time, we will introduce to you the Duo chart, a custom visual that puts two types of charts side by side. Over a two-week series we will go through how to build such charts with an intriguing example.


Power Query: Revision Time – Part 8

29 May 2024

Welcome to our Power Query blog. Today, I continue to create a refreshable revision timetable by continuing to transform the Availability query.


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

28 May 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.CALCULATIONGROUPS.


A to Z of Excel Functions: The RAND Function

27 May 2024

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


Excel for Mac: Missing Pop-Up Buttons

24 May 2024

This week in our series about Microsoft Excel for Mac, we show you a few handy pop-up buttons that are unfortunately not going to pop up if you’re using Excel on a Mac.


Power BI Blog: Refreshing Time on Power BI Service – Part 2

23 May 2024

Welcome to our Power BI blogs. Over two weeks, we will show you how to manage time-refreshing on Power BI Service.


Power Query: Revision Time – Part 7

22 May 2024

Welcome to our Power Query blog. Today, I continue to create a refreshable revision timetable by creating a list of all the subject slots I need for the timetable.


Newsletter