Marco Russo's blog posts of 2017

Page 2 of 25 blog posts
blog post –

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

blog post –

The new data modeling book for Power BI and Power Pivot users

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

blog post –

Avoid measure and column with the same name in #dax

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

blog post –

Unexpected side effects of table filters in #dax

One of the side effects that you might not expect from a table filter in a CALCULATE statement is the removal of an existing filter. In reality, this is a condition that happens when you write an explicit CALCULATE in a row context, because the table  Read more