DAX

ARTICLE

Using KEEPFILTERS in DAX

This article explains how to use KEEPFILTERS to intersect instead of overriding an existing filter context in DAX, simplifying the code and improving performance.

ARTICLE

The easiest way to start using variables in #dax

A few months ago, I and Alberto realized that the reason why variables are not used in DAX as they should is that… there are not many examples out there! For this reason,¬†we made a commitment to use them more often in our example. We didn’t do that in 2015

ARTICLE

Sessions and preconference at Microsoft Ignite and PASS Summit

In the second half of 2017 I will deliver sessions and preconference days in two big events. I’d like to recap my sessions here, let me know if you have any questions about them. Microsoft Ignite 2017 – September 25-29, 2017 – Orlando, FL Preconference full day – September 24

ARTICLE

Local #dax measures in #powerbi reports are not visible from #Excel

You can connect an Excel workbook to a Power BI model in two ways: Using the Analyze in Excel action in powerbi.com Using the Connect to Data action in the ribbon of Power BI publisher for Excel In both cases, you have the ability to choose either a report or

ARTICLE

Generating a series of numbers in DAX

This article describes how to create a table with a series of numbers in DAX by using the new GENERATESERIES function or through a workaround using CALENDAR.

ARTICLE

New function and the importance of variables in #dax

I recently wrote a few articles about a new function in DAX and the use of variables. For those of you using Power BI or Azure Analysis Services, you always have access to the latest version of the language. Well, in reality I see that new features appears

ARTICLE

Using GENERATE and ROW instead of ADDCOLUMNS in DAX

This article explains how to improve DAX queries using GENERATE and ROW instead of ADDCOLUMNS when you create table expressions.

ARTICLE

Using the SELECTEDVALUE function in DAX

This article describes how the SELECTEDVALUE DAX function simplifies the syntax required in many scenarios where you need to read a single value selected in the filter context.

ARTICLE

Defining variables in DAX queries

This article shows how to define variables in DAX queries and introduces the differences in scope when there are multiple EVALUATE statements.

ARTICLE

User group meetings and #dax training in Minneapolis and Chicago

In the next three weeks I will deliver many speeches and training in United States. Here is the list: June 11, 2017 : Precon Data Modeling with Power BI at Microsoft Data Insights Summit (Seattle, WA) June 12, 2017 : Workshop DAX 101 at Microsoft Data