Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The MULTINOMIAL Function

5 September 2022

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


Charts and Dashboards: Chart Titles as a Text Box Revisited

2 September 2022

Welcome back to this week’s Charts and Dashboards blog series. This week, we revisit creating attention grabbing chart titles.


Power BI Blog: More on Datamarts

1 September 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how you can now better connect to datamarts within Power BI Desktop.


Power Query: Check the Filters - Part 2

31 August 2022

Welcome to our Power Query blog. This week, I look at how the options on the Transform tab can filter a query, saving both time and steps.


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

30 August 2022

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 COUNT.


Monday Morning Mulling: August 2022 Challenge

29 August 2022

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: August 2022 Challenge

26 August 2022

On the final Friday of each month, we are going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you are playing for bragging rights only!


Power BI Blog: Composite Models and Dynamic M Query Parameters Part 3

25 August 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we conclude our series by looking at how to use a ‘Select all’ option in the slicer referencing M parameters.


Power Query: Check the Filters - Part 1

24 August 2022

Welcome to our Power Query blog. This week, I look at how checking the filter options can save time and steps.


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

23 August 2022

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 COTH.


Newsletter