Marco Russo's Blog posts of 2014

Page 6 of 59 results

The Cumulative Total #dax pattern

The first pattern published on is the Cumulative Total . Another common name of this calculation is Running Total, but the reason why we named the pattern in this way is that we identify all those scenarios in which you want to obtain  Read more

How to obtain last process date from #SSAS #Tabular

I wrote an article about how to get the Last Process Date in SSAS Tabular . This is a common request and there are many ways to obtain this information. You can use the metadata provided by XMLA or DMV, just as you can do in SSAS Multidimensional. Or  Read more

Scheduled Data Refresh in Power BI #powerbi #powerpivot

Now that Power BI is finally available (I still use terms as “released” for software and “in production” for a service…) I made some test on the new Scheduled Refresh option that you have for your models (other info here . First of all, the Refresh feature  Read more

Distinct Count in DAX Query Plans #dax #tabular

In the last months I and Alberto Ferrari worked on many consulting engagements about designing Tabular models or optimizing existing ones. One of the strength of the Tabular model compared to Multidimensional is the performance of distinct count measures.  Read more

Using Added Columns in #DAX Queries

I had an issue in a query that reminded me a few details naming columns created by ADDCOLUMNS. When you specify a simple name in ADDCOLUMNS, you can use it later, for example in a SUMMARIZE or in a FILTER expression, such as in the following example (see  Read more