- that data model is now truly a thing of beauty. I think of DAX as the smartest kid in class, but who is really susceptible to peer pressure. If you give it a bad crowd to hang out with, it quickly turns into a juvenile delinquent. But paired with a good data model like that, it’s a straight A student.
Now if you want to really supercharge that model, replace your calendar table with @Melissa’s Extended Date table:
This will give you a ton of functionality to make time intelligence analysis easier and further simplify your DAX. (She and I will be starting a time intelligence video series centered around this extended date table next week on the Enterprise DNA YouTube Channel).
Good luck with the rest of your analysis! Give a shout if you have any other problems.
- Brian