Power BI

This article explains how to use SUMMARIZECOLUMNS, which is a replacement of SUMMARIZE and does not require the use of ADDCOLUMNS to obtain good performance

If you do not have a full month with data, comparisons such as year-over-year (YOY) might require particular filters in order to do a like for like comparis

It’s is often handy to be able to define a table in line with your calculation. Apparently, you can do it in DAX using the following syntax: { value1, value1, value3} The statement above crea…

Finding Duplicates in PowerPivot – Within Current Table (HasDupeInThisTable) or Across Tables (HasDupeInTable2) I got a question on Twitter today wh

Hi guys.   I have a table with these columns:   Item No, Date, and Price   I want to add a fourth column, Latest Price. Latest Price looks at all rows with the same Item No, finds the latest Date out of all those rows, and gives me the Price from that row.     Item No Date Price Latest Price 12345 J...

In any version of DAX, you can aggregate data by grouping one or more columns using SUMMARIZE and/or ADDCOLUMNS. In Excel 2016, Power BI Desktop, and Analys

DAX Patterns is a collection of ready-to-use data models and formulas in DAX, which is the programming language of PowerPivot. Create your Excel data model faster by using a DAX pattern!

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