5 Worst DAX Mistakes You’re Probably Making

Поделиться
HTML-код
  • Опубликовано: 12 янв 2025

Комментарии • 42

  • @benndii
    @benndii 16 дней назад +1

    Another year passed where I learned A LOT from you. Thank you!

  • @GoodlyChandeep
    @GoodlyChandeep  19 дней назад +6

    🎄✨ 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 - ruclips.net/video/yw0QHu9V4UQ/видео.htmlsi=aT7Faov5gTyVkjbs
    🎥 5 DAX Debugging Tricks! - ruclips.net/video/Lsw7w-_z-m8/видео.htmlsi=1tde71xtWqEJcuKH

    • @RohitSharma-uw2eh
      @RohitSharma-uw2eh 8 дней назад

      Sir, there is no need to create separate Hindi videos. For the videos already on your English channel, you can use RUclips'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.

  • @remuslupinhp
    @remuslupinhp 18 дней назад +3

    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.

  • @emanuelecostantinocatanzar3042
    @emanuelecostantinocatanzar3042 2 дня назад

    Wow, Excellent, as usual!
    Mistakes 4 and 5 are really pitfalls. Thank you for sharing this. 🙏

  • @kkravch
    @kkravch 19 дней назад +3

    Thank you. I specifically liked the one with Month/Index and Totals

  • @APG67-q8l
    @APG67-q8l 8 дней назад

    Excelente, Chandeep, explicación muy clara. Muchas gracias por todo lo que enseñas.

  • @shrishailnaik1403
    @shrishailnaik1403 10 дней назад

    This is awesome explanation! 👏🏻 Thank You!

  • @ajinkyashinde1778
    @ajinkyashinde1778 8 дней назад

    Once again, the simple yet highly effective video from Goodly-kudos!❤

  • @siddharthwarrier9736
    @siddharthwarrier9736 14 дней назад

    Excellent video, very helpful. Probably the best that you have put up on your channel till now. Thanks and keep up the good work!

  • @gospelmoto2833
    @gospelmoto2833 17 дней назад +1

    Bravo! Real-life cases. Excellent. Thank you Goodly.

  • @teigenxayden
    @teigenxayden 19 дней назад

    the last 2 examples are so important! THX a lot.

  • @IvanCortinas_ES
    @IvanCortinas_ES 19 дней назад

    As good as always. Excellent resolution of these 5 cases. Thank you very much. And Merry Christmas.

  • @zhihaowu208
    @zhihaowu208 19 дней назад

    Happy holidays 🥳! Thank you again for another amazing video.

  • @bernardarhin2628
    @bernardarhin2628 9 дней назад

    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?

  • @SteveisRio
    @SteveisRio 19 дней назад

    Thanks for sharing your View On how to cleverly use DAX function to get accurate insights

  • @mnowako
    @mnowako 19 дней назад

    Thank you for the amazing content, and Merry Christmas to you and your team!

  • @markdhenderson1
    @markdhenderson1 19 дней назад

    Well done! So clearly explained and presented. You are my favorite. Thank you.

  • @martyc5674
    @martyc5674 18 дней назад

    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.

  • @shivraghava5421
    @shivraghava5421 12 дней назад

    Kudos!! This is what i missed with another tutors,

  • @gauravguliani358
    @gauravguliani358 17 дней назад

    This is such a mind-blowing video Chandeep

  • @arbazahmad7177
    @arbazahmad7177 17 дней назад

    Excellent... thanks for sharing...

  • @krishna6296
    @krishna6296 17 дней назад +1

    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.

  • @steveprether9363
    @steveprether9363 18 дней назад

    Very helpful! I'm sure I've made all of these at one time or another.

  • @fernandomanzanares5555
    @fernandomanzanares5555 18 дней назад

    #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

  • @devendrabarasker4987
    @devendrabarasker4987 19 дней назад +1

    Last one was very helpful 🙌🙌

  • @shripaddeshpande5766
    @shripaddeshpande5766 17 дней назад

    Great and helpful 👍🏻

  • @ОлегПетров-ю4п
    @ОлегПетров-ю4п 18 дней назад

    Thank you again for another amazing video.

  • @krishnaRaog21
    @krishnaRaog21 19 дней назад

    Very useful video

  • @pawewrona9749
    @pawewrona9749 5 дней назад

    I think passing entire table as argument in FILTER function should also be one of the common DAX mistakes.

  •  17 дней назад

    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!

    • @GoodlyChandeep
      @GoodlyChandeep  17 дней назад

      wow.. I love to see how my voice sounded in Portuguese. We're living in exciting times.

  • @pankajsharmadelhi93
    @pankajsharmadelhi93 19 дней назад

    Hi chandeep I'm also looking something on fabric

  • @phamhung4042
    @phamhung4042 18 дней назад

    The last one is super

  • @LAMIAAMOHAMMAD
    @LAMIAAMOHAMMAD 13 дней назад

    Amazing

  • @captivatedCoder
    @captivatedCoder 18 дней назад

    Best tip in this video: Error messages aren't very helpful.

  • @RohitSharma-uw2eh
    @RohitSharma-uw2eh 8 дней назад

    Sir, there is no need to create separate Hindi videos. For the videos already on your English channel, you can use RUclips'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.

  • @teigenxayden
    @teigenxayden 19 дней назад

    Merry Christmas, Chandeep! 🎅,thanks a lot for your share !

  • @RogerStocker
    @RogerStocker 19 дней назад

    As usual: "Tricky cases explained easy."

  • @AtikurRahman-f9q
    @AtikurRahman-f9q 19 дней назад

  • @Wzxxx
    @Wzxxx 12 дней назад

    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