This is one of the best videos explaining DAX... DAX is one of the weirdest languages to learn for non-coders... My biggest mistake was to start learning DAX without knowing any other coding language. If someone has prior coding experience, DAX becomes so much easier. At times, we think that DAX is counterintuitive, but when you know another language, you understand what are the simplifications made in DAX. A simple concept like iterators seems so alien if you have no coding background, but when you have it, iterators become so very obvious... So I would suggest to everyone, to first learn another language, you learn one, you can quickly grasp another. And then start working with DAX. DAX can open a whole new world if you know how to, but it can be hairsplitting if you don't know how.
🎄✨ Merry Christmas, everyone! 🎅🎁 Here are some resources: ✅ Download the Power BI file - goodly.co.in/5-worst-dax-mistakes 🎥 How to Fix Incorrect Totals in Power BI - ua-cam.com/video/yw0QHu9V4UQ/v-deo.htmlsi=aT7Faov5gTyVkjbs 🎥 5 DAX Debugging Tricks! - ua-cam.com/video/Lsw7w-_z-m8/v-deo.htmlsi=1tde71xtWqEJcuKH
Sir, there is no need to create separate Hindi videos. For the videos already on your English channel, you can use UA-cam's new feature to add multiple language audio tracks. Just add a Hindi audio track to all your videos. Viewers will be able to listen in both English and Hindi.
On mistake number 3, would you then recommend that rows are taken from the dimension table always? Are there situations where taking rows from the fact table works the same and what are the risks?
Hey Chandeep, For #3, yes it is a mistake. However, just curious if we still want to use Sales(Year) and DaysinYear, we can change the cross filter direction to both(bidirectional cross filtering). I think that should work. Please correct me if I am wrong.
A dublagem do vídeo ficou excelente! Eu sempre recomendei o canal mas as pessoas tinham dificuldade por causa da linguagem, pois agora muito mais pessoas podem ter acesso a esse conteúdo de qualidade! Parabéns!
Sir, there is no need to create separate Hindi videos. For the videos already on your English channel, you can use UA-cam's new feature to add multiple language audio tracks. Just add a Hindi audio track to all your videos. Viewers will be able to listen in both English and Hindi.
Couple years ago I spent a week to figure out why why I cannot remove filter from a month. Btw the thing you did - removing the filter from a month like this can lead to the most unexpected error in PBI - due to autoexist „feature” (or a bug). For a date table it still might work correctly but not for other tables. There is now an option turn it off but…welcome to hell anyway. I don’t even mention arbitrate shape sets error. Power BI is not for a casual user:). There is always much higher chance that things go wrong then correct in PB even for simple math concepts
Another year passed where I learned A LOT from you. Thank you!
Thank you so much
This is one of the best videos explaining DAX... DAX is one of the weirdest languages to learn for non-coders... My biggest mistake was to start learning DAX without knowing any other coding language. If someone has prior coding experience, DAX becomes so much easier. At times, we think that DAX is counterintuitive, but when you know another language, you understand what are the simplifications made in DAX. A simple concept like iterators seems so alien if you have no coding background, but when you have it, iterators become so very obvious... So I would suggest to everyone, to first learn another language, you learn one, you can quickly grasp another. And then start working with DAX. DAX can open a whole new world if you know how to, but it can be hairsplitting if you don't know how.
🎄✨ Merry Christmas, everyone! 🎅🎁
Here are some resources:
✅ Download the Power BI file - goodly.co.in/5-worst-dax-mistakes
🎥 How to Fix Incorrect Totals in Power BI - ua-cam.com/video/yw0QHu9V4UQ/v-deo.htmlsi=aT7Faov5gTyVkjbs
🎥 5 DAX Debugging Tricks! - ua-cam.com/video/Lsw7w-_z-m8/v-deo.htmlsi=1tde71xtWqEJcuKH
Sir, there is no need to create separate Hindi videos. For the videos already on your English channel, you can use UA-cam's new feature to add multiple language audio tracks. Just add a Hindi audio track to all your videos. Viewers will be able to listen in both English and Hindi.
Thank you. I specifically liked the one with Month/Index and Totals
Wow, Excellent, as usual!
Mistakes 4 and 5 are really pitfalls. Thank you for sharing this. 🙏
Last one was very helpful 🙌🙌
Once again, the simple yet highly effective video from Goodly-kudos!❤
the last 2 examples are so important! THX a lot.
Bravo! Real-life cases. Excellent. Thank you Goodly.
This is such a mind-blowing video Chandeep
Excellent video, very helpful. Probably the best that you have put up on your channel till now. Thanks and keep up the good work!
This is awesome explanation! 👏🏻 Thank You!
Kudos!! This is what i missed with another tutors,
Well done! So clearly explained and presented. You are my favorite. Thank you.
Excelente, Chandeep, explicación muy clara. Muchas gracias por todo lo que enseñas.
As good as always. Excellent resolution of these 5 cases. Thank you very much. And Merry Christmas.
I dip I and out of DAX a lot for short periods and “relearn” a lot - that second explanation was just brilliant - I always struggle with this.
Happy holidays 🥳! Thank you again for another amazing video.
Very helpful! I'm sure I've made all of these at one time or another.
Thanks for sharing your View On how to cleverly use DAX function to get accurate insights
Thank you again for another amazing video.
Great and helpful 👍🏻
Excellent... thanks for sharing...
Thank you for the amazing content, and Merry Christmas to you and your team!
#4 taught me something new! And I think I now know why I was getting weird results in certain scenarios...
#5 was a great solution
On mistake number 3, would you then recommend that rows are taken from the dimension table always? Are there situations where taking rows from the fact table works the same and what are the risks?
Hey Chandeep, For #3, yes it is a mistake. However, just curious if we still want to use Sales(Year) and DaysinYear, we can change the cross filter direction to both(bidirectional cross filtering). I think that should work. Please correct me if I am wrong.
I think passing entire table as argument in FILTER function should also be one of the common DAX mistakes.
The last one is super
Very useful video
A dublagem do vídeo ficou excelente! Eu sempre recomendei o canal mas as pessoas tinham dificuldade por causa da linguagem, pois agora muito mais pessoas podem ter acesso a esse conteúdo de qualidade!
Parabéns!
wow.. I love to see how my voice sounded in Portuguese. We're living in exciting times.
Merry Christmas, Chandeep! 🎅,thanks a lot for your share !
Amazing
Hi chandeep I'm also looking something on fabric
Best tip in this video: Error messages aren't very helpful.
Sir, there is no need to create separate Hindi videos. For the videos already on your English channel, you can use UA-cam's new feature to add multiple language audio tracks. Just add a Hindi audio track to all your videos. Viewers will be able to listen in both English and Hindi.
As usual: "Tricky cases explained easy."
❤
Couple years ago I spent a week to figure out why why I cannot remove filter from a month. Btw the thing you did - removing the filter from a month like this can lead to the most unexpected error in PBI - due to autoexist „feature” (or a bug). For a date table it still might work correctly but not for other tables. There is now an option turn it off but…welcome to hell anyway. I don’t even mention arbitrate shape sets error. Power BI is not for a casual user:). There is always much higher chance that things go wrong then correct in PB even for simple math concepts