If you didn't find what you were looking for, try a new search!
Prioritizing questions around DAX Studio 3, optimization, performance, DAX, data modeling, processing, etc... 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 Do NOT re-post your questions! We'll get to as many questions as we can. 👉 If you [...]
We thought that DAX was the thing in Power BI. Alex proves the M-M-Magic is really with Power Query! If you wanted to be blown away but what Power Query can do, this is the video for you! Connect with Alex: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ Power Query folding https://docs.microsoft.com/power-query/power-query-folding 30 Day Challenge: Query Folding https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N Power Query [...]
Sometimes you want to highlight the lowest value in a Power BI visual. First you need to find it! Then you can highlight it. What if you want to ANIMATE it? Patrick shows you how to do just that! ALLSELECTED() article: https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/
Not a coder? Don't understand DAX syntax? DAX can be intimidating and difficult to learn. Frustrating even! Learning DAX can make Power BI very rewarding. Adam has some resources to get you started in your journey. Beginning the journey MS Learn: User DAX in Power BI Desktop (Free) SQLBI: Introduction to Data Modeling for Power [...]
Learn how you can trace your DAX queries when trying to troubleshoot or optimize Power BI reports and datasets. There are a few options and Adam walks you through them. DAX Studio: https://daxstudio.org/ SQL Server Management Studio: https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 Visualize Your Refresh: https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/
Learn how to get your DAX measures in working order, using DAX Studio, before putting them in your Power BI report. Patrick walks you through it! SQLBI article: https://www.sqlbi.com/articles/hiding-future-dates-for-calculations-in-dax/ Hiding Future Dates video: https://www.youtube.com/watch?v=VXd1wl-5vKI
We know that DAX, in Power BI, can be intimidating. We've been there. Patrick shows you how you can learn DAX using what you have available today and TAME the beast that is DAX! DAX.Guide: https://dax.guide DAX Studio: https://daxstudio.org/ DAX Patterns: https://daxpatterns.com Microsoft Learn: https://docs.microsoft.com/learn/paths/dax-power-bi/ Download Sample
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup203 Patrick's tech video: https://guyinacu.be/paginated2021 Adam's tech video: https://guyinacu.be/whatispowerbi 🔴 Live Replay: https://guyinacu.be/live037 📢 Become a member: https://guyinacu.be/membership Sources DAX Studio 2.14 Release (@darrengosbell) ALM Toolkit in Power BI (@HowToPowerBI) Why is DAX so difficult to learn? (@CurbalEN) Exploring new [...]
You may be able to write a DAX expression, but what about an actual DAX query? DAX queries can help you validate data and fine tune your DAX expressions used for Power BI. Patrick shows you how!
Too many rows? How is that possible? Patrick looks at a case where a customer hit an error of too many rows coming back from a DAX statement in Power BI.
