In todays video I will review the COALESCE function a.k.a koala function and show you some cases where this function is useful. I also answer Question 2 of the Microsoft Power BI exam and ask question 3. Happy Friday! Link to sqlserver tutorial: https://www.sqlservertutorial.net/sql-server-basics/sql-server-coalesce/ Link to sqlbi article: https://www.sqlbi.com/articles/the-coalesce-function-in-dax/ Answer to question 2: https://docs.microsoft.com/en-us/power-bi/power-bi-data-sources Power BI exam 70-778 Question 2: https://www.youtube.com/watch?v=hGj2axffxHo Answer Q3: https://www.youtube.com/watch?v=9SV2VnYbgg4 Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU Link to DAX Fridays survey: http://bit.ly/2MMM4KK Here you can download all the pbix files: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: https://curbal.com/courses-overview ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance!Here you can download all the pbix files: https://curbal.com/donwload-center ▲▲▲▲▲▲▲▲▲▲ Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ************ ************ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► https://goo.gl/3VW6Ky Twitter ► @curbalen, @ruthpozuelo Facebook ► https://goo.gl/bME2sB #daxfridays #curbal #SUBSCRIBE