DAX - Excelerator BI

DAX

Excel

Major Update to Power Pivot

I have been blogging about DAX since before Power BI was a product; I started back in 2014 and Power BI was first released as generally available in mid 2015.  Until about 2017, the only way you could build a commercially viable production reporting tool that used DAX was via […]

Read More »

Exploding Measures using Tabular Editor 3

What?! Exploding Measures I hear you say. Exploding, expanding, use which ever word you like; what I mean is when you want to remove any refence to a measure INSIDE another measure. Example Consider the 3 measures below. Total Sales = SUM(Sales[ExtendedAmount]) Total All Product Sales = CALCULATE([Total Sales],ALL(Products)) % […]

Read More »

Nsw Health 2

What does the Data Say?

I have a very simple video today with not a lot of DAX needed; I just want to demonstrate how you can gain insights from data.  On 10th Sept 2021, NSW health made a material change to the Active Cases reported for COVID-19 in Australia (as you can see in […]

Read More »

Variables

Variables in DAX

Earlier this week I did a live stream event.  I put out a poll and asked people to tell me what topic they wanted me to talk about.  The options were Calculated Columns vs Measures Tips for Excel users moving to Power BI Using Variables in your DAX The overwhelming […]

Read 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 »

Scroll to Top