| Days Since Last Event: TSQL vs. MDX vs. DAX |
| Written by Christian Wade |
| Tuesday, 18 January 2011 02:06 |
|
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.
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
