DAX for Power BI Part 2.3 - The Switch Function

[@robworcester]

Hi Andrew. I just would like to express my gratitude for what you do here. I have watched around 150 of your videos on ssrs, sql server and power bi. Your way of explaining report builder, sql and databases helped me to learn reporting within 12 months from zero to hero, where I am now one of the most experienced in the team of 12 people of a big logistics company’s BI team. It’s all thanks to you. You are by far the best teacher I ever had who is solely responsible for the incredible pace of me being able to learn all this. Keep up the great work!

[@WiseOwlTutorials]

Hi Robert, that's so nice to hear! I'm really happy that the videos have helped you so much, congratulations on your success and thank you for taking the time to write such a nice comment!

[@kavehyarohi2886]

Hi Andrew, just wanted to say thank you for this brilliant series. Super useful stuff. and as always your way of explaining is just otherworldly. great great material.

[@WiseOwlTutorials]

You're very welcome, thank you for taking the time to leave a comment and for watching!

[@wayneedmondson1065]

Thanks Andrew. Got behind.. catching up on this excellent series now. Looking forward to more! Thumbs up!!

[@WiseOwlTutorials]

Cheers Wayne, glad you're enjoying it!

[@MohamedAhmed-training]

Wonderful Teaching Video

[@WiseOwlTutorials]

Thanks Mohamed!

[@nikakalichava8012]

Thanks, Mr. Owl!

[@WiseOwlTutorials]

You're welcome Nika!

[@mePrafull]

Thank you for creating this i learned much topics here

[@WiseOwlTutorials]

You're very welcome, thank you for watching!

[@rajeshkumar-fd8sv]

Very Nice Andrew. Thanks

[@WiseOwlTutorials]

Thanks Rajesh!

[@hadibq]

Thanks Andrew for the excellent quality of your tutorials! I have a suggestion please... Could you kindly include in the description the playlist where videos belong to, that would help getting into the playlist when one finds the video after a search in yt. Thanks again!

[@WiseOwlTutorials]

Hi Hadi, thanks for the suggestion! Just so you know, you can find a link to the DAX playlist in the end screen of each DAX video and you can find all our playlists from the channel homepage kzbin.infoplaylists I hope it helps!

[@marnitztaylor9509]

Thanks you!

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@travelkare]

Hi Andrew , Great video, Thank you once again. I was searching video or playlist on power query ( data modelling )and power bi service? Please help

[@WiseOwlTutorials]

Hi! We don't have a series for Power Query or the Power BI Service at the moment, but I plan to have these in the new year!

[@travelkare]

Yes i will wait @@WiseOwlTutorials

[@Ronnet]

Would love to have a multi criteria switch function, especially in power query. That would solve so many problems.

[@WiseOwlTutorials]

Hi! I'm not quite sure if I've understood what you need but you can combine criteria in a DAX Switch function using the && (and) and || (or) operators, for example: Category = SWITCH( TRUE(), Movies[Run Time] < 100 && Movies[Oscar Wins] = 0, "Short Loser", Movies[Run Time] < 100 && Movies[Oscar Wins] > 0, "Short Winner", Movies[Run Time] < 150 && Movies[Oscar Wins] = 0, "Medium Loser", Movies[Run Time] < 150 && Movies[Oscar Wins] > 0, "Medium Winner", I'm not sure if that helps.

[@tejamarneni]

Hi Andrew, thank you for the amazing Video. Can you please make a Video on Group By in Power BI?

[@WiseOwlTutorials]

Hi Teja! We plan to have a video which includes the GroupBy function along with similar functions like Summarize and SummarizeColumns. Thanks for watching!

[@tejamarneni]

@@WiseOwlTutorials Thank you Andrew. Looking forward to your videos.

[@trideepnath]

Hi Andrew, For my case i am getting an error for sorting part.. Failed to save modifications to the servers. 'A circular dependancy was detected :SpocRa[Band],SpocRa[Band Sort],SpocRa[Band]'.. Can you please help?

[@WiseOwlTutorials]

Hi! I'm guessing your [Band Sort] calculated column uses an expression which refers to your [Band] column? And then you're attempting to set the Sort By option for the [Band] column using the [Band Sort] column. As you've discovered, you can't do this. One slightly awkward way to solve this is to create a third column which duplicates the data in the [Band] column, for example: Band Sorted = SpocRa[Band] You can then use the [Band Sort] column as the Sort By column for the [Band Sorted] column. Not very elegant but it works. I hope it helps!

[@munichandrakuppani8103]

Hi Andrew, what is Advanced Filter in VBA? What is Option Base in VBA? How to create more than one column's filter in VBA While writing VBA code, what are the best tips in VBA? How to improve performance of VBA code? Please tell, what are the story of these Questions, please don't skip, please explain? Sorry to asked Here

[@excelvbatrick7308]

1.How many parameters (value,result) can give in switch function? 2. Can I use array ( Multiple condition) in value with { } for same result?

[@limichael1519]

Hi Andy I think u had a haircut 😁

[@WiseOwlTutorials]

I did! Thanks for noticing 😀

[@bernardarhin2628]

How do I use SWITCH(TRUE) to solve this based on the Movies data: Create a column using SWITCH(TRUE()) to classify studios as "Small" (produced < 5 films), "Medium" (5-15 films), "Large" (more than 15 films).

[@WiseOwlTutorials]

Hi! It depends which set of Movies data you're using - this video only has a single table and doesn't include the Studio column. Are you using a version of Movies with a separate Studio table or one with a Studio column in the same table as the films?