DAX

This is actually the fifth post on Slicers, which means that it’s something that keeps coming up and that its something important to learn.

One type of analysis I like to use quite often is comparing this year totals to last year totals. I want to also always make it as dynamic as possible. All I should have to do is change the context of my calculation (ie. bring in a new dimension like regions/products etc) and everything should autom...

It’s been almost two years since I posted about the CONCATENATEX() DAX function here. At the end of that post I promised to publish a tutorial on how one might do Market Basket analysi…

<< Back to Part 1 Download this workbook Here The Formula for the Slope of a Linear Regression Line.  It’s Greek to Me.(Get it?  Gree

Technical articles, content and resources for IT Professionals working in Microsoft technologies

DAX Patterns is a collection of ready-to-use data models and formulas in DAX, which is the programming language of PowerPivot. Create your Excel data model faster by using a DAX pattern!

This article describes different techniques to retrieve multiple values from a lookup table in DAX, improving code readability and performance. There are a

Jumpstart your DAX development with this helpful cheat sheet.

Gaining an understanding of Row and Filter Context is among the most difficult challenges facing a new DAX author. Just when you think you've got it, a problem arises and your hard-won mental model seems to crumble before your eye. For a new author this is particularly tricky in that virtually every...

KPI for easy Profit and Loss in PowerBI as the last part of my series: Learn how to write them for columns and rows with minimal efford.

Sometimes reporting data values day-by-day can create the impression of dramatic ups and downs, when really what we want to see is the general trend of changes over time.  We need, in other words, to create a chart based on moving averages.  Such a measure is commonly used in tracking the price of stocks, but […]

Egg on My Face For Improper Use of EARLIER() Tonight I was looking at one of my recent posts, the one about “fuzzy” time relationships in calculated

“…then they start thinking that, ‘where there’s smoke there’s fire’ logic…” Continuing the Impromptu Series of Simple Real World Examples The Mr. Ex

EARLIER is a DAX function that acts exclusively on row context,  and its purpose is to create a reference to a column value on an outer loop of the evaluation of the expression.  It is commonly use…

Last month, I explored how to take a Power BI area chart and make it into a unique “new” chart type using only data and DAX formulas. The line chart is also a candidate for a bit more f…

You might have used FIRSTNONBLANK and LASTNONBLANK in semi-additive measures, but you might not be aware that their use is not limited to time intelligence

DAX Patterns is a collection of ready-to-use data models and formulas in DAX, which is the programming language of PowerPivot. Create your Excel data model faster by using a DAX pattern!

I recently discussed with Darren Gosbell about how to calculate the Median in DAX. The problem is to make the calculation using a measure, so that you can use it in a dynamic way into a PivotTable. We have a People table with three columns: Gender, Customer

I was helping out in the Power BI Community and I came across the following requirement. The user had sales figures and based on the Previous month, they wanted to have an arrow showing if it was u…

“AGAIN!” -Pai Mei       SUMX() – the great iterator Have you ever written an array formula in Excel?  (Don’t worry