AI does a much better job at writing DAX if we give it model context. Here’s how to do that using TMDL!
We’ll go through how to do this using both GitHub Copilot via VS Code and the browser version of Claude 3.7 Sonnet.
🛠️ RESOURCES
Prompt text here: https://christine-payton.com/ai-create-dax-measures/
🍀 CHAPTERS
0:00 - Intro
0:51 - Turn on TMDL
1:15 - Creating measures with AI using whole model as context
4:09 - Tips for success
5:19 - Creating measures with AI using targeted context
6:20 - Troubleshooting errors
7:30 - Using Claude in browser to create measures
▶️ WATCH NEXT
- Use AI to create descriptions and comments for measures:
https://youtu.be/7vIwgSE8qmQ
🎓 COURSE
https://christine-payton.com/course/
CONNECT WITH ME
📩 Get new videos via email! - https://bi-ome.kit.com/youtube
📝 Blog - https://christine-payton.com/
🔗 LinkedIn - https://www.linkedin.com/in/christinehpayton/
💬 Questions? Drop them in the comments! Your question could help others too.
#tmdl #ai #llm #powerbi