DAX on AUTOPILOT: Copilot's Performance Will Surprise You!

Unlock the power of Copilot in Power BI with Mitchell Pearson! 🚀 Watch as he tests Copilot's ability to generate production-ready DAX, including YTD, running totals, and conditional KPIs. Get a deep dive into where Copilot excels with syntax, starters, and explanations, and discover when you need to step in for more complex logic! Learn smart prompt patterns and validate your DAX using the DAX Query View. 🧑‍💻

#PowerBI #Copilot #DAX #DataAnalysis #RunningTotals #KPIs #PowerPlatform #DataScience #DAXTips #BusinessIntelligence

👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

⏰ Timestamps for easy navigation:
🕒 00:00 - Can Copilot write DAX?
🕒 00:21 - DAX Query View & Copilot setup
🕒 01:02 - Fabric capacity requirements
🕒 01:37 - YTD Sales with Copilot
🕒 02:56 - Keep & Explain in DAX Query View
🕒 03:38 - Add the measure to your model
🕒 04:31 - Fiscal YTD (June 30 year-end)
🕒 06:18 - Advanced: Top 5 + Bottom 10
🕒 08:14 - Why SUMX here?
🕒 08:58 - Alternative approach: CALCULATE + TREATAS
🕒 10:02 - Validate AI-generated DAX
🕒 11:12 - Takeaways & wrap-up

Let's connect:

✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li

Pragmatic Works
350 Governor St, Suite 300, Green Cove Springs, FL 32043
Phone: (904) 638-5743
Email: [email protected]
#PragmaticWorks