Topic: Power Pivot
-
I hadn’t time in the last two months for new blog posts, but with some good reasons! I’ve been busy putting DAX Formatter online and writing some other stuffs that I will be happy to share very soon, aside from daily engagements with customers, of course. Read more
-
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
-
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
-
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
-
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
-
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
-
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
-
This time Microsoft listened to the many complaints received since Excel 2013 release and the stand-alone version of Excel now includes Power Pivot and Power View! This is a very important news because there were customer who didn’t upgrade from Excel Read more
-
In the last weeks the Microsoft BI buzzword has been Power BI for Office 365, which will be available soon in preview. I read a few comments about the fact that there is a constant discussion about the future but a lack of information and discussion about Read more
-
Alberto Ferrari wrote a very interesting white paper about DAX query plans. We published it on a page where we'll gather articles and tools about DAX query plans: http://www.sqlbi.com/topics/query-plans/ I reviewed the paper and this is the result of Read more