Topic: MDX
Learn DAX, data modeling, and data visualization after MS Data Insight Summit #dax #powerbi #dataviz
I spent three days in Seattle at Microsoft Data Insight Summit , delivering a preconference day about data modeling for business users, and two workshops about DAX. All of these were sold-out, so even if you attended the conference, you might be interested Read more
Many-to-many relationships in DAX and CROSSFILTER #dax #powerbi #powerpivot #ssas #tabular
I wrote many articles and white papers about implementing many-to-many relationships in Analysis Services – for both Multidimensional and Tabular models. For the latter, the same techniques are also useful in Power Pivot and Power BI. With the recent Read more
New formula to compute new customers in #dax
Two years ago I and Alberto Ferrari spent time discussing techniques to calculate new and returning customers, and we wrote the result of our study in the New and Returning Customer article in DAX Patterns web site and book . During one of the Mastering Read more
Internet of Things in 2015 #summit15 #sqlpass
David DeWitt and Rimma Nehme delivered the day 2 keynote at PASS Summit 2015 talking about Internet of Things. Many PASS attendees know David for providing some of the best keynotes every, technical and without vaporware and marketing stuffs. So this Read more
When to use calculated tables in #dax
In the September release of Power BI Desktop, Microsoft introduced a new important feature: calculated tables. Chris Webb wrote a quick introduction to this feature, and Jason Thomas published a longer post about when to use calculated tables . The reason Read more
Fix performance issue of pivot tables with Tabular models
If you use SSAS Tabular, this is a very important news! Microsoft released a very important update for Analysis Services 2012 that provides performance improvements to pivot tables connected to an Analysis Services Tabular model: it is SQL Server 2012 Read more
Passing parameters to DAX measures
You cannot create functions in DAX, and this is a limitation to certain abstractions you might want to implement for complex models. I used a pattern that allows you to “pass an parameter” to a DAX measure, simulating the behavior of a function at least Read more
DAX Studio 2.2 released – tracing support for #powerpivot and much else! #dax
Thanks to Darren Gosbell we have DAX Studio 2.2. In this new release: Tracing (query plans and server timings) available for Power Pivot Basic implementation of Intellisense Connect to Multidimensional SSAS servers Support for multiple Power BI Desginer Read more
SQL Saturday #454 and Expo 2015 – fill the survey and submit sessions! #sqlsatexpo
The 2015 is a special year for Italy, because the country hosts Expo 2015, which is the current Universal Exposition. For this reason, the Italian PASS chapter promotes a special edition of SQL Saturday, a free training event for SQL Server professionals. Read more
DAX measures in Power BI Designer – and new DAX syntax finally here
The last update of Power BI Designer allows you to create measures (not calculated columns yet). Download the new version of Power BI Designer and you will see the New Measure button. The editor is much better than anything you have seen in Excel 2010/2013, Read more