...and of course also how to do it "properly". If you want to keep the rest of the columns while expanding, check part 2: https://youtu.be/hJF2dPfIeaM 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 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 ☼☼☼☼☼☼☼☼☼☼ 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 ************ MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too! COUPON: CURBAL10 Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance! ************ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► https://goo.gl/3VW6Ky Twitter ► @curbalen, @ruthpozuelo Facebook ► https://goo.gl/bME2sB #CURBAL #SUBSCRIBE

Power bipowerbiCurbalpower bi desktoppower bi tutorialpower bi trainingpower bi for beginnersruth pozuelogetting files from folder power querymissing columns power querygetting files from folder missing columns power queryget data from folder