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: https://www.youtube.com/c/excelfort?s...

⏲ 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:
https://excelfort.com/why-do-my-dax-f...

👨‍🏫 For Instructor-led virtual training programs, visit:
https://excelfort.com/training/ or 📧 [email protected]

🟢 LET'S CONNECT!
------------------------------------------------------
✔   / excelfort  
✔   / excelfort  
✔   / excelfort  
✔ Email: [email protected]
✔ Mobile No: 00966509791858

#excelfort #powerbi #msexcel #powerquery #powerapps #data