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

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

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

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

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

I recently wrote an article that describes how to calculate a measure (such a sales, but it could be anything else) considering for each customer its first 12 months, then months 13-24 and so on. In practice, for every customer you have a different range  Read more

Alberto Ferrari recently recorded a free short video introduction about what is time intelligence . When you have to perform time-related calculations in Power Pivot or in Analysis Services Tabular, you have to rely on some DAX expressions. There are  Read more

A couple of weeks ago, I wrote a blog post about MCSM for BI certification . This raised an interesting discussion about the reasons why such a certification does not exists, whether it was really necessary, what it should include, and so on. There was  Read more

I recently wrote an article on SQLBI describing the dynamic calculation of stock inventory in DAX. With this technique, you can avoid creating a snapshot fact table just to store the inventory stock for every day and every product, creating a table that  Read more

Two years ago Microsoft started a certification program called SSAS Maestro , which was intended to be as a step towards a broader certification such as a Microsoft Certified Architect (MCA) or Microsoft Certified Solution Master (MCSM) for Business Intelligence  Read more