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

Hi,   I want to build a graphic with Power BI displaying the order growth percentage in last 30 days or 12 months.   I have a table 'orders':   id date 10001 2016-12-12 11:16:00 10002 2016-12-12 11:17:00 10003 2016-12-12 11:18:00   I would like to display the rolling growth percentage of the number ...

Hi , I am working on out power bi dashboard and receive request from Managment that they want to see total number of items added daily. Currently when I do this it just filter it buy that year or month and shows items added on that particular month or year. But not total items added upto now. As sho...

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…

What this is going to explain below is how I use a parameter that a user has entered to make a Dynamic Calculated Measure based on the Parameter entered. Example Scenario In my model I have got Par…

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

Experienced Analysis Services and Power Pivot developers will know all the interesting things you can learn from DMV queries. For example, in this blog post Kasper de Jonge shows how to use a DMV t…

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