Time intelligence solved with modelling and crossfilter instead of DAX measures
A while ago I came across this interesting time intelligence solution that doesn’t use DAX measures to do time intelligence but rather solves it through the model. The pattern was created by the great Greg Galloway from Artis Consulting and I am blogging this with his permission.
This solution allows users to select time ranges from the model to be applied to any measure (and not build it in for every measure), for example YTD, last week, last 14 days, MTD and so on like this: