DAX

Simple Filters and Syntax Sugar in DAX

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 for people to learn and use the DAX language. Here are a couple of examples Total...

read more

Semi-Additive Measures in DAX

NOTE: this article replaces a previous versions published in 2013 and based on Power Pivot. Semi-additive calculations are quite the challenge for any BI developer, and DAX is no exception. These measures are not hard to compute; the complex part is understanding the...

read more

Using DAX with DateTime values

I was recently reading an interesting question by a user. Given a date/time value and a number of hours, add the number of hours to the date, but considering some constraints related to working hours: The working hours are 09:00-17:00 Non-working days do not count...

read more

Steps To Mastering Power BI & DAX

TO VIEW REPLAY & DOWNLOAD RESOURCE REGISTER HERE - https://enterprisedna.co/webinar-replay-steps-to-mastering-power-bi-dax/ When is it? March 20th - 5pm New York (EDT), 2pm Los Angeles (PDT) , 9pm London (GMT) - March 21st - 8am Sydney (AEDT), 10am Auckland (NZST)...

read more

Creating Calendar Table in Power BI using DAX Functions

I have previously written about using Power Query for creating calendar tables, However, some people still love to do that in DAX. There are a couple of DAX functions which makes the process of creating a calendar table very simple and easy; Calendar() and...

read more

Creating Calendar Table in Power BI using DAX Functions

I have previously written about using Power Query for creating calendar tables, However, some people still love to do that in DAX. There are a couple of DAX functions which makes the process of creating a calendar table very simple and easy; Calendar() and...

read more

Counting working days in DAX

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 delivery dates. DAX can compute the difference between two dates by subtracting one from the other. This produces the...

read more

Computing running totals in DAX

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 calculation (YTD), which aggregates values from the beginning of the year all the way to a certain date. A simple...

read more

Calculation Groups in DAX – first impressions

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 will have on Analysis Services and Power BI. The Calculation Groups provide the ability to create items that are...

read more

Hiding future dates for calculations in DAX

This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates. DAX time intelligence functions such as year-to-date (YTD), year-over-year (YOY), and several others come in handy when...

read more

Detect missing parameters in DAX queries

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 manage missing parameters of a DAX query? I wrote an article in the past describing how to use parameters in a DAX...

read more

DAX error messages in Power BI

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 Power BI. A DAX expression containing syntax errors stops the execution of the calculation. These errors are...

read more

Naming variables in DAX

There is an existing limitation in the current version of DAX, regarding what names you provide to variables in a DAX expression: a variable name cannot be the name of a table in the data model. This is not a big issue if you create DAX expressions after importing all...

read more
Share This