Topic: PowePivot
A small change in DAX Formatter and in DAX formatting rules
DAX Formatter was created in 2013 to help users format their code based on the Rules for DAX Code Formatting published in October 2012. Because the main goal is to make the code immediately readable and recognizable, DAX Formatter purposely… Read more
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
Using OR conditions between slicers in DAX
This article describes how to implement in DAX a logical OR condition between the selection of two slicers of a Power BI report or of a PivotTable in Excel. By default, when relying on more than one slicer they are… Read more
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
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
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
Year-over-year comparison using the same number of days in #dax
When you use the time intelligence functions in DAX, it is relatively easy to filter the same dates selection in the previous year by using the SAMEPERIODLASTYEAR or DATEADD functions. However, if you follow the best practices, it is likely that you have Read more
Upcoming conference speeches and workshops in 2016 #ssas #tabular #dax #powerpivot #powerbi
The summer is almost over and while we are working on new content (books and other for www.sqlbi.com ), I already have the plans for this Autumn’s conferences. Microsoft Ignite 2016 – September 26-30, Atlanta, GA See what’s new in SQL Server Analysis Read more
Upcoming conference speeches and workshops #ssas #tabular #dax #powerpivot
Between May and July I and Alberto will be speaker at several conferences, and I think it could be useful to write a single blog post with a recap: PASS Business Analytics Conference 2014 – May 7-9, 2014 – San Jose, California Querying in DAX (Marco Russo) Read more
From 0 to DAX at TechEd Pre-Conference Seminar #dax #msteched #tee13
In June I and Alberto will deliver a pre-conference seminar at both TechEd North America (New Orleans, LA) and TechEd Europe (Madrid, Spain). This day is a very good quickstart for those of you that still didn’t complete one of our books , or those of Read more