Absolutely – I think that’s the only way to develop true proficiency with DAX. The videos provide a fantastic foundation, but it’s only when you get in and try to do it yourself that it will really “click”. @sam.mckay has some great suggestions in the video below for how to practice using the resources in the eDNA portal:
To these, I would add two additional suggestions:
- Consider working through the eDNA Certification.
This is a great structured learning opportunity that will dramatically improve your DAX capabilities. The first of the four modules is relatively straightforward, and they get increasingly difficult through the next three. If you really challenge yourself and watch a video or go to another resource only when you are truly stuck, by the time you complete all four modules you will have mastered a wide range of DAX functions and analytical approaches.
- Try Responding to Questions on the eDNA Forum
IMO, this might be the best learning opportunity on the site. Questions range from very basic to incredibly difficult. Pick ones you think you can answer and try to work through a solution. Even if you’re not able to solve it, the process of doing so will make the solutions posted by others much more meaningful. By working through other members’ problems, you will gain exposure to DAX functions, data model structures, Power Query approaches, etc. that you might never see in your own projects. And over time, when you look back at your earlier solutions, you’ll see very clearly how much you’ve improved. Plus, while you’re learning, you’re also helping others. It’s been great to see more and more members diving in recently and doing this on the forum.
I hope this is helpful. Good luck practicing.