Measuring the dictionary size of a column correctly
This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular.
This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular.
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
This article explains how to improve DAX queries using GENERATE and ROW instead of ADDCOLUMNS when you create table expressions.
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.
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
SQLBI offers a new introductory DAX video course called Introducing DAX. This article describes which users will benefit more from this learning experience, and how to enroll in the course.
Is there a secret recipe to create a beautiful dashboard? Why do we need to use “beautiful”? Would “useful” be a better adjective? If you think for a moment, you know that we are attracted by the “beautiful”. It is important for a first impression, but
In the last few years, I and Alberto Ferrari assisted many users of Power Pivot and Power BI who wanted to create their reports using these tools and were struggling with getting the desired numbers from their data. The first approach of an Excel user
I recently wrote an article about duplicated names in DAX to highlight a possible case where you can have a measure with the same name of a column. This is not a good idea, mainly because the syntax to reference a measure and a column is identical, and
This article describes how DAX resolves column and measure names in DAX, providing best practices to avoid conflicting names.