dax

Hi,   I recently wrote a DAX measure based on some help I got on this forum. However I now see that these measures are very consuming in terms of memory and slow my report down way too much. I have a table with the following structure: I have one line per person giving me the name of that person and...

The RANKX function in Power BI might have an unexpected behavior when applied to a column that has a specific sort order in the data model. This article exp

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

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…

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…

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

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

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

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

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.

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

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 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

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

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

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

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

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

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] ) ))

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…

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