Days Since Last Event: TSQL vs. MDX vs. DAX

Written by Christian Wade on 17 January 2011. Posted in MDX

I have often had to report the "days since last event". I'm going to do it here using a variety of query languages and compare them.

Consider the following TSQL query on AdventureWorksDW - and the output below.