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

Written by Christian Wade on 18 January 2011.

User Rating: 5 / 5

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.