Excelerator Blog - Articles on Power BI, DAX, Data Modelling & more

Building a Matrix with Asymmetrical Columns and Rows in Power BI

I have written a few articles that are related to this topic (articles that utilise this same technique to solve a problem), but never before have I explained the stand alone concept of how to build a visual with asymmetrical columns and rows in Power BI.  Let me explain with […]

Read More »

Part 2 – Filtering Out BLANKS in a MEDIANX Measure Using DAX Studio

This article is a follow on from last week. I recommend you go back and read the article first if you missed it, but in summary, I want to write a measure (not a calculated column) that will return the median sales of products while excluding the products with blanks (no […]

Read More »

Power BI 5th Birthday

Power BI Birthday Number 5

I’m sure many of you will already know that today is Power BI’s 5th birthday. It has been another great year of development by the Power BI team at Microsoft and the product has literally become so compelling that virtually every organisation should be considering deploying this tool. I cite […]

Read More »

Scroll to Top