dax

Today I ran across a pretty straightforward DAX challenge that is made so much simpler thanks to variables. So I decided to share it. Remember folks use variables for each...

The current version of DAX has a limitation for names you can provide to variables in a DAX expression: a variable name cannot be the name of a table in the

This is a companion article to my talk, “Working with advanced DAX Models”. It includes some links to documentation, the slide deck, and the PBIX file used in the demos. I am planning t…

This article describes the real meaning of and the required action for a few common error messages that can appear when users define DAX expressions in Powe

DST Refresh Date Function Power BI Service. For Power BI service, the local time is UTC (Universal Time Coordinated). Quick tip on creating a custom function to get local time year-round, even with da…

This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates. DAX ti

Yesterday I answered to a question related to parameters in DAX that could be useful to other readers who use DAX in Reporting Services (SSRS): how to manag

Recently, I was helping someone on Power BI community forum on the issue of calendar over run while comparing values with last year’s data. I thought it would make a good article to share wit…

This article describes how to display the filter context applied to a calculation using a special DAX measure in Power BI Tooltips. Understanding the filte

Microsoft announced at SqlBits a very important feature for DAX: Calculation Groups. These are my first impression about the new feature and the impact it w

Information, tips, news and announcements about Azure Analysis Services (Azure AS) and SQL Server Analysis Services (SSAS) directly from the product team.

With the release of CTP 2.3 of SQL Server 2019 today there was big news for Analysis Services Tabular developers: Calculation Groups. You can read all about them in detail in this blog post: In my …

Introduction One of the first things that befuddles people that know other coding languages when learning DAX is the absence of constructs for traditional “for” and “while” loops. This is a well understood limitation and just generally accepted by people who have learned DAX. However, when answering...

I woke up Saturday morning to a lot of chatter and blog articles about an announcement that Microsoft made at SQL Bits. Microsoft is adding “Calculation Groups” to the DAX language. Th…

This article shows how to compute a running total over a dimension, like for example the date. A very common calculation in DAX is the year-to-date calcula

Optimization has become one of my favorite topics. OK, I’ll admit it: it might be an obsession and a source of joy. My inability to optimize (queries, data models, and DAX) used to be a source of headaches and the occasional heart attack depending on what I was trying to accomplish. I make no claim that I’m an

This Power BI blog post details how to easily edit long measures that are created in Power BI desktop and how to use the Data View

Hello P3 Nation! After having the privilege of working with so many of you to share your journeys and techniques I was inspired to share my own. This is a bit of an intimidating group, and I struggled a bit with what to share. After much deliberation, I compromised with myself on a journey story. My journey does not

This article shows a DAX technique to compute the number of working days between two dates. The example includes a Sales table containing order and deliver

Alberto Ferrari joins Patrick to walk through how you can use DAX to format a list of values within Power BI Desktop. This takes the concatenate values quick measure to the next level. Original Quick Measure video Alberto’s article

One of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI. Last week, John asked me how to apply…

Level: Intermediate There is a concept in the DAX language called “Syntax Sugar”. Simply put, the developers have created simplified versions of more complex formulas to make it easier…