Topic: PowePivot

       36 blog posts
blog post –

VertiPaq Analyzer 2.0 Preview 1

In 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used with Analysis Services and Power BI.  Read more

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