In this video, I will show you why sometimes your DAX formulas return wrong results. I will also show you how to easily fix them in Power BI and explain what exactly causes the unexpected results in your DAX calculations or formulas.
The video goes into the various DAX errors mistakes that beginner of Power BI developers generally make when they write them. These errors can sometimes be complicated, but this video breaks down each one so it's easy to understand.
💚 Subscribe to this channel: youtube.com/c/excelfort?sub_confirmation=1
⏲ Video Timestamps
00:00 - Intro
00:33 - Example 1 – Zero and Blank problem
02:41 - Example 2 – Incorrect Grand Total
05:55 - Example 3 – % of total not adding-up to 100%
08:05 - Example 4 – DAX Variable causes incorrect results
10:43 - Example 5 – Wrong % for monthly contribution to year
12:43 - Example 6 – RANKX returns one on every line/row
15:04 - Example 7 – SWTICH return wrong results for sales band
17:03 - Ending
⏬ You may download the completed PBIX file here:
excelfort.com/why-do-my-dax-formulas-return-wrong-results/
👨🏫 For Instructor-led virtual training programs, visit:
excelfort.com/training/ or 📧 info@excelfort.com
🟢 LET'S CONNECT!
------------------------------------------------------
✔ facebook.com/excelfort
✔ twitter.com/excelfort
✔ linkedin.com/company/excelfort
✔ Email: info@excelfort.com
✔ Mobile No: 00966509791858
#excelfort #powerbi #msexcel #powerquery #powerapps #data
- Why My DAX Formula Returns Wrong Result Learn Why & How to Fix it in Power BI ( Download)
- Power BI DAX Webinar | Why Do My DAX Formulas Return Wrong Results | M365 Chicago ( Download)
- How to fix Incorrect Measure Total in PowerBI | MiTutorials ( Download)
- How to Fix Incorrect DAX Measure Totals and What Causes Them ( Download)
- Dax Fridays! #177: My DAX measure is incorrect, how do I troubleshoot it ( Download)
- How to fix Incorrect Totals in Power BI ( Download)
- HOW TO FIX MATRIX TOTALS IN POWER BI | WHY YOUR TOTAL IS INCORRECT IN POWER BI | INCORRECT TOTAL ( Download)
- Why Incorrect Totals in Power BI How to Fix Incorrect totals | MiTutorials | #PowerBI ( Download)
- Why My DAX Formulas Return Wrong Results by Fowmy Abdulmuttalib #GPPB2022 #PowerAddictsBE ( Download)
- Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand ( Download)
- Power BI & DAX: What to Do When Power BI Totals are Wrong ( Download)
- How to FIX Incorrect Measure Totals in Power BI | Power BI Interview ( Download)
- Why Power BI totals might seem wrong ( Download)
- How to TROUBLESHOOT and FIX most common ERRORS in Power BI // Beginners Guide to Power BI in 2022 ( Download)
- Power BI Shows Incorrect Measure Total How to fix it ( Download)
