Welcome back to this week’s edition of the Power BI blog series. This week, we look at a new feature enabling you to dynamically change measures and / or dimensions.

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

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.

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

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.

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

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

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.

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?

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.