Great - glad that was helpful. This is one of the awesome things about the forum - questions not only lead to answers for the initial poster (and anyone else with a similar question), but they also serve as one of the best means of practice for those answering questions. And regular practice is really the only way to improve your DAX once you have the basics down.
The other best form of practice is the data challenges. If you really want to improve your DAX (and data modeling, and power query and visualization…) quickly, the challenges really represent the best investment of practice time IMO.
Here’s a video I put together on the specific strategies I’ve found most useful for improving DAX (and M) skills that you may find helpful in structuring your own practice routine:
Re: time intelligence, everyone develops their own DAX style and approach. Some folks on the forum are masters of the entire lexicon of time intelligence functions. I’ve taken the opposite approach -pretty much all I know and use are: DATEADD, DATESBETWEEN, DATEDIFF, TODAY and occasionally EOMONTH. Combine this with @Melissa’s awesome extended date table and a knowledge of how to use the offsets in that table:
and you’ve pretty much got everything you need in 4-5 functions.
Hope this is helpful. Always a pleasure working with you.
- Brian