Marco Russo's blog posts of 2013
Power Query now imports relationships #powerquery #powerpivot
The December release of Power Query preview (version 2.9.3502.261) introduced an interesting feature: when you import multiple tables in the data model, relationships existing between tables in the data source are automatically detected and added to the Read more
Format your #dax code with DAX Formatter
When you write a DAX formula that is not trivial, you end up having a complex expression that is not really readable. I think that the same problem affect in part all Excel users, but in Excel you can easily split a formula in many steps, using different Read more
Videos about #DAX on Project Botticelli
More than one year ago, I and Alberto started recording videos for Project Botticelli, and now we have a set of videos about DAX that you can watch online. There are a few videos free, and others are available in the monthly subscription. If you are interested, Read more
Updates about Multidimensional vs Tabular #ssas #msbi
I recently read the blog post from James Serra Tabular model: Not ready for prime time? (read also the comments because there are discussions about a few points raised by James) and the following post from Christian Wade Multidimensional or Tabular . Read more
PowerShell Script to Deploy Multiple VM on Azure in Parallel #azure #powershell
This blog is usually dedicated to Business Intelligence and SQL Server, but I didn’t found easily on the web simple PowerShell scripts to help me deploying a number of virtual machines on Azure that I use for testing and development. Since I need to deploy, Read more
PowerShell Script to Deploy Multiple VM on Azure in Parallel #azure #powershell
This blog is usually dedicated to Business Intelligence and SQL Server, but I didn’t found easily on the web simple PowerShell scripts to help me deploying a number of virtual machines on Azure that I use for testing and development. Since I need to deploy, Read more
Difference between LASTDATE and MAX for semi-additive measures in #DAX
I recently wrote an article on SQLBI about the semi-additive measures in DAX . I included the formulas common calculations and there is an interesting point that worth a longer digression: the difference between LASTDATE and MAX (which is similar to FIRSTDATE Read more
Using USERELATIONSHIP function in Measures and Calculated Columns #dax #powerpivot #ssas
You can use the USERELATIONSHIP function in DAX to apply a non-active relationship in a particular DAX calculation. This approach is usually simple in a measure (just use USERELATIOSHIP in one of the filter arguments of CALCULATE) but as soon as you try Read more
SSAS Tabular Workshop in 3 days with hands-on-labs #ssas #tabular #dax
I and Alberto Ferrari delivered many SSAS Tabular Workshops in the last 18 months and based on the feedback we received, we are moving toward a renewed edition. Instead of a 2-day seminar, we will run a 3-day course including hands-on-labs. We didn’t Read more
Handling Wrong or Missing Dates in Tabular and #powerpivot #dax
Recently I received a request from a reader related to the handling of missing or invalid dates in Tabular (but the same can be applied to Power Pivot). In the Analysis Services Tabular book , we wrote that you can insert a special row in the Date table Read more