Topic: SSAS
-
We are approaching the end of 2017, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is going to happen in 2018. New DAX… Read more
-
In the second half of 2017 I will deliver sessions and preconference days in two big events. I’d like to recap my sessions here, let me know if you have any questions about them. Microsoft Ignite 2017 – September 25-29,… Read more
-
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
-
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
-
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 Read more
-
If you run SSAS Tabular or Power BI, please help me in gathering some performance data for a study I'm doing about Formula Engine performance following these steps: 1) Copy the PowerShell code below in a script Benchmark.ps1, modifying serverName, ssasInstanceName Read more
-
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
-
Last year I and Alberto Ferrari wrote a new edition of the Analysis Services Tabular book, which official title is Tabular Modeling in SQL Server Analysis Services (2nd Edition) . Some delay in editing and production delayed the printing, but the book Read more
-
More than one year ago, I and Alberto Ferrari started to work on DirectQuery, exploring the new implementation appeared in Analysis Services 2016 for the Tabular models, which uses the same engine of Power BI. The previous version of DirectQuery appeared Read more
-
I recently wrote an article to described in more details the syntax of the IN operator in DAX , which is available in Power BI and in the CTP of the next release of Analysis Services. Jeffrey Wang wrote a blog post about the IN operator a few months ago, Read more