You searched "dax"
        Page 2 of 532 results
DAX 101 –

Year-to-date filtering weekdays in DAX

Time intelligence functions oftentimes hide an automatic ALL statement meant to make time intelligence calculations easier. This article describes this behavior and what to do in case it ends up breaking your calculation.  Read more

blog post –

Hate and love for the DAX language

A few weeks ago I woke up on a Saturday morning with a question notified on my Quora feed: Why do all the BI consultants hate DAX? I was challenged to answering the question because I personally love DAX but…  Read more

article –

Semi-Additive Measures in DAX

Values such as inventory and account balance, usually calculated from a snapshot table, require the use of semi-additive measures. This article describes how to implement these calculations in DAX according to your specific requirements.  Read more

blog post –

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…  Read more

blog post –

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.  Read more

blog post –

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…  Read more