DAX

Easy way to create typical finance reports like Profit and Loss using DAX that (unlike other solutions I've seen so far) can be handled with very basic know

DAX calculations can leverage relationships present in the data model, but you can obtain the same result without physical relationships, applying equivalen

My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a DAX formula. She had a Power BI dashboard in which she needed a very particular interac…

Sales_OldCustomer = CALCULATE ( SUM ( Sales[Amount in USD] ), FILTER ( Sales, YEAR ( Sales[Date] ) > RELATED ( Customer[Created Year] ) ))Sales_NewCustomer = CALCULATE ( SUM ( Sales[Amount in USD] ), FILTER ( Sales, YEAR ( Sales[Date] ) = RELATED ( Customer[Created Year] ) ))

Yeah actually my bad on the ALLSELECTED function, the behaviour is quite different from what I thought it was. Cool you found a soltion.   For the other one, can you change "MAX(DegreeConferred[TERM_END_D​ATE]))" to the equivalent field in your term table? That way it should have a value even when t...

Technique to do correlation in DAX with thanks to  for teaching me about VAR statement. This creates a correlation between forecasting table and wages tables:   In forecasting, create the following custom column: CorrelateX2 = // Gregory J Deckler - 2/18/2016 // Create a new column that subtracts...

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

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

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

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

PowerPivot DAX Cheat Sheet - list of sample formulas for calculated columns and measures

For the RunningAverage Column use the expression   RunningAverage = Averagex ( Filter ( YourTable, YourTable[Pod] = Earlier ( YourTable[Pod]) && [Complete]

This article describes the semantic difference between ALLEXCEPT and the joint use of ALL and VALUES, showing practical examples of the different results in

This article explains how to create a calculated column in DAX to get a sequential number identifying the events related to a particular entity. In a model

If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them do not work with the new tabular models. For example, the MDSCHEMA_MEASUREGROUP_…

This article analyzes how to efficiently work with events that lasts over time, such as the duration of an order considering the distance between order date

In this post you learn how to use "IN" operation in DAX. You also learn how to create and use Power BI Desktop grouping feature.

The SQL Server Data Tools (SSDT) editor for Tabular models has been improved in the recent updates. For example, the Tabular Model Explorer enables you to quickly jump between the entities of your model organized in a hierarchical way. However, when it

I am constantly amazed at how much you can achieve in Power Pivot with a relatively small amount of DAX knowledge.  I was working with a client recently an

Dynamic duration calculation for events with start- & end date that can exclude weekends and holidays using DAX for Power BI and Power Pivot

Alberto Ferrari has recently published a very smart concept how to analyze events with a duration in DAX, which you should read here, if you haven

Last week, at the SQL Server Days conference in Belgium, Kasper mentioned in his presentation that it was possible to define variables inside variables in DAX. So, for example, you could define a m…

Variables are the best thing to happen to DAX since, well forever – they are so cool I’m almost ready to like DAX as much as I like MDX. There are already several good articles and blog posts out t…

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