DAX for Power BI Part 2.4 - Working with Blanks

[@frailove_6125]

I learned a lot from your nice videos for VBA 3-4 years ago and managed to deal with a lot of complicated works, and I am learning Power BI tutorial from you again! LOVE your way of mixing useful tips with similar difficulty! what a master! I would like to say thank you a lot!

[@WiseOwlTutorials]

So happy to hear that you've found the VBA and DAX videos useful! Thanks for taking the time to leave a nice comment and for watching!

[@jaynekingg1159]

I am learning so much from these tutorials. Thank you!

[@WiseOwlTutorials]

You're very welcome, happy to hear you're finding the videos useful and thanks for watching!

[@TheJokerShacoOTP]

Ty mister Owl, I'm learning from Chile - South America, I really appreciate your hard work, this is the only way I can learn from the best professionals in the world, greetings.

[@WiseOwlTutorials]

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

[@anilpothuru5651]

Your dax videos are crystal clear Love from 🇮🇳 India 🇮🇳

[@WiseOwlTutorials]

Thanks Anil, happy to hear you're enjoying the DAX series. Thanks for watching!

[@tejamarneni]

Hi Andrew, this series has been really helpful.Thank you so much for the awesome videos. Looking forward for the entire series.

[@WiseOwlTutorials]

My pleasure Teja, thanks for the comments and support!

[@pavaniDusari]

Hi Andrew such a helpful video you have covered all the Dax functions in the tutorial. Thanks it helped me 🥰🥰

[@WiseOwlTutorials]

Happy to hear that you found it useful, thanks for watching!

[@shoaibrehman9988]

Sir It is gr8 gr8 stuff i have ever watch so far, what a detail explanation, which shows your expertise. Thanks for sharing your knowledge 🙏 👍

[@WiseOwlTutorials]

Happy to hear that you found it useful, thanks for watching and for leaving a comment!

[@wayneedmondson1065]

More great instruction! Thanks Andrew :)) Thumbs up!!

[@WiseOwlTutorials]

Thanks again Wayne!

[@fadwa2413]

Perfect,Keep Going Please YOU ARE THE LEGEND

[@WiseOwlTutorials]

Ahh thank you! More DAX on the way soon!

[@gates1978]

Very helpful as always. Thank you .

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@sandipkadam6041]

Very nice explanation...

[@WiseOwlTutorials]

Thank you!

[@alexrosen8762]

Excellent tutorial! Thanks :-)

[@WiseOwlTutorials]

You're very welcome, glad you enjoyed it and thanks for watching!

[@yashrajpatidar7645]

How to automatically auto reply an email in excel vba and we can set any type of matter like hello, hi or a photo or a attachment

[@bp2807]

Very nice .just wanted to know how much data can we import in power bi. Also what is the meaning of . If you have chosen to keep the Excel experience, instead of importing the data, the limit is 250 MB for the dataset? Kindly explain

[@WiseOwlTutorials]

1) It depends how much money you have (scroll down this page to find the model size limit) powerbi.microsoft.com/en-gb/pricing/ 2) In the Power BI service you can import or connect to Excel files. Connecting keeps the Excel experience. docs.microsoft.com/en-us/power-bi/connect-data/service-excel-workbook-files#one-excel-workbook--two-ways-to-use-it

[@bp2807]

@@WiseOwlTutorials thanks for the reply .also the second part of the query that is . If you have chosen to keep the Excel experience, instead of importing the data, the limit is 250 MB for the dataset . Kindly explain the meaning. Thanks

[@WiseOwlTutorials]

@@bp2807 Hi, the second link I posted explains that part. I hope it helps!

[@bp2807]

@@WiseOwlTutorials Thanks

[@nikakalichava8012]

Thanks again, Mr. Owl! Question: This time a have a question. 19: 30 Made in = Movies[Title] & " was made in " & COALESCE(Movies[Country]," Unknown") The way COALESCE works is it adds the value to that BLANK row? So if we had second blank value what would happen? Should the formula be: Made in = Movies[Title] & " was made in " & COALESCE(Movies[Country]," Unknown", " Unknown") and it adds second value to the second empty cell? EDIT: Instead of waiting I checked it myself: For 2 empty rows with expression: Made in = Movies[Title] & " was made in " & COALESCE(Movies[Country]," Unknown") it returns "Unknown" for both empty cells in Country, But what is [Value22] in COALESCE?

[@WiseOwlTutorials]

Hi Nika, COALESCE simply returns the first value which isn't blank from the list of values you provide to the function's arguments. A calculated column is evaluated for each row of the table independently, so you don't need to account for multiple rows which may be blank. I hope that helps!

[@nikakalichava8012]

@@WiseOwlTutorials Okey, that makes it clearer. Thanks a lot!

[@nationfirst-worldaffairs6410]

Plz free just dax tutorial unlock free ...I will Prayer for best wishes 🙏🙏