DAX for Power BI Part 2.2 - The If Function

[@marvinmachitar7229]

7:39 instead of typing 1000000000, we can abbreviate it to 1e9. Anyway, this video is so helpful. Goodjob WiseOwl! :D

[@WiseOwlTutorials]

That's a great tip, thank you for taking the time to share it! :D

[@NilimaParbatani]

this is by far the best series to give confidence to use DAX out of so many other videos i have watched. Great work Andrew!

[@WiseOwlTutorials]

Thanks so much! Happy to hear that you found it useful so far, thank you for watching and taking the time to comment!

[@fadwa2413]

Good Morning, I just want to thank you so much for your sincere, elegant way of teaching us, powerful Series, I am still on the second Lesson and I feel become a ninja, Thank you so much for spending time to teach us!!
Have a nice day,Mr Andrew

[@WiseOwlTutorials]

You are very welcome! Thank you so much for the kind comments, I really appreciate it!

[@sadiyakiduniya786]

So far the best tutorial to learn DAX in power BI. Could you also make some useful videos on how to create interactive dashboard in Power BI

[@tejamarneni]

Hi Andrew, thank you so much for the amazing video. I learned a lot on Power BI by watching your videos. You are the best Andrew.

[@WiseOwlTutorials]

You're very welcome! Thanks for the nice comment and for watching!

[@wayneedmondson1065]

Awesome Andrew! Learned some new tricks with operators watching this one. Thanks for sharing :)) Thumbs up!!

[@WiseOwlTutorials]

Cheers Wayne, glad you enjoyed it!

[@akhilsingh5251]

Wow amazing knowledge share by you i really appreciate your efforts.
Thank you ❤❤❤

[@DanielTeixeiradeLimaDani]

Sou Brasileiro e estou aprendendo funções DAX Power Bi com você. Pude ver em um vídeo anterior onde você criava uma tabela, então nessa aula de 'Using the In Operator' 27:55 eu tentei usar os dois métodos e funcionou.
Fave Directors = IF(
Movies[Director] IN
SELECTCOLUMNS(
FILTER(
Movies,
Movies[Oscar Wins] >= 1 &&
Movies[Nominations] >= 3 &&
Movies[Box Office] >= 1000000000
),
"Diretores",
Movies[Director]
)
,
"Favourite",
"Standard"
)

[@kebincui]

You are the best Andrew👍👍

[@WiseOwlTutorials]

Ahh thanks Kebin!

[@Adeyeye_seyison]

Thanks a million sir, for the great learning videos...
You're amazing sir

[@WiseOwlTutorials]

Thanks for watching!

[@adepressedman7156]

Thanks WiseOwl. Please make a series on power bi data model.

[@WiseOwlTutorials]

You're welcome and thanks for the request!

[@bretaddison4146]

Nice tutorial. How can you use if to return the contents of a column ie to create a column based on criteria from other columns. Is this possible ?

[@AbhishekYadav-rb4bi]

Thank you 🙌

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@juliajankowska853]

Thank you very much for your great work:)

[@WiseOwlTutorials]

You're very welcome Julia, thank you for watching!

[@nikakalichava8012]

Thanks a lot!

[@WiseOwlTutorials]

You're welcome, thanks for watching Nika!

[@nihalisahu3857]

Nice vid sir😀

[@WiseOwlTutorials]

Thanks for watching!

[@yashsomaiya8141]

Download the source data here linl is not working

[@anilkumarp9055]

Great tutorial. One small doubt, when I am placing Oscar Success on Y-axis then it is showing count of Oscars as 6 for Genre Family but when we place Oscar Success in Legend section it is showing count of Oscars as 0. When I see the Movies data, there are no Oscars for Family Genre. In Movies data, there are 6 records for Genre Family, it is showing that count. Could you please help me in understanding this scenario.

[@WiseOwlTutorials]

If you place Oscar Success in the y-axis you'll get the count of values produced by the calculated column for each genre. Hope it helps!

[@anilkumarp9055]

@@WiseOwlTutorials thank you 😊

[@scooble]

20:28 - substitute Michael Bay for Uwe Boll for truly awful movies

[@WiseOwlTutorials]

There are so many terrible directors to choose from! :D

[@gigiben5430]

lol