Home
> PowerPivot, SQL Analysis Services, SQL Script > FW: Days Since Last Event: TSQL vs. MDX vs. DAX
FW: Days Since Last Event: TSQL vs. MDX vs. DAX
There is a nice blog discussing “Days Since Last Event”, you can find it here.
It compares the same logic implemented by TSQL, MDX and DAX. In my perspective, the TSQL is the most easy to understand. The MDX (2nd solution) is elegant. The DAX one is the hardest to understand. (Tips: don’t read the DAX code in the text, read from the screenshot and the code is formatted better).
Categories: PowerPivot, SQL Analysis Services, SQL Script
Comments (0)
Trackbacks (0)
Leave a comment
Trackback