Please note javascript is required for full website functionality.

Blog

Power Query: See it, Save it, Sort it - Part 4

8 June 2022

Welcome to our Power Query blog. This week, I reorganise the data from my appended queries.


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

7 June 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 CONCATENATEX.


A to Z of Excel Functions: The MINUTE Function

6 June 2022

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


Charts and Dashboards: Data Tables - Part 2

3 June 2022

Welcome back to our Charts and Dashboards blog series. This week, we’ll go step-by-step through the process of constructing a one-dimensional Data Table.


Power BI Blog: Canvas Zoom

2 June 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the newly-announced Canvas Zoom.


Power Query: See it, Save it, Sort it - Part 3

1 June 2022

Welcome to our Power Query blog. This week, I append queries to extend my data.


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

31 May 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 CONCATENATE.


Monday Morning Mulling: May 2022 Challenge

30 May 2022

The challenge this month was to create a PivotTable that showed the sales amount made by each salesperson in their individual business units, as well as a percentage breakdown for each business unit and the percentage contribution of each business unit to total sales. Easy, yes?


Final Friday Fix: May 2022 Challenge

27 May 2022

We are all aware that Power Pivot works with the DAX (Data Analysis Expression) language. Power Pivot employs DAX for data modelling, and it is simple to use for self-service BI. Data tables and columns in data tables are the foundation of DAX. It's worth noting that it's not reliant on individual cells in the table like Excel's formulae and operations are. Data Analysis Expressions (DAX) may appear overwhelming at first, but the fundamentals of DAX are simple. However, as we continue to try to tackle ever more challenging challenges, we occasionally reach some hard boundaries.


Power BI Blog: Power BI Known Issues Page

26 May 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the newly launched Known Issues page.


Newsletter