What's the missing LINK?! Combining ACTUALS and FORECAST as one LINE in Power BI

In this video I show you how to combine connect actuals to forecast in a visual. I explore the different approaches and their impact on the results in DAX. Enjoy the video and subscribe for more Power BI hacks! Download file here https://datatraining.io/powerbi-how-to -------------------------------- 📊 TRAININGS 📊 --------------------------------- Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation Power BI Essentials https://datatraining.io/powerbilearningpath Business User Training https://datatraining.io/powerbi-business-users For Custom Trainings and Consulting email directly [email protected] --------------------------------- ⏱️ TIMESTAMPS ⏱️ --------------------------------- 0:00 Intro 00:37 Getting the last actuals date 03:13 Combining actuals and forecast using the IF function 05:05 Combining actuals and forecast using the CALCULATE function 06:42 Alternative with KEEPFILTERS 08:43 Creating a chart with a connecting actuals and forecast line 09:35 End --------------------------------- 😍 JOIN 😍 ---------------------------------- Join https://bit.ly/4b453bi Subscribe https://bit.ly/31MnQGO​ Insta https://www.instagram.com/howtopowerbi/ LinkedIn https://www.linkedin.com/in/basdohmen/ TikTok https://www.tiktok.com/@how.to.power.bi X https://twitter.com/HowToPowerBI fb https://www.facebook.com/groups/howtopowerbi Threads https://www.threads.net/@howtopowerbi Newsletter https://datatraining.io/newsletter --------------------------------- 👇 CHECK THIS OUT! 👇 --------------------------------- 💻 My gear https://amzn.to/47F21Yc 📚 Power BI books MUST READ! https://amzn.to/3tUfFcj 💡 General books I recommend https://amzn.to/48YNo33 🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj 🚀 For growing on YouTube: https://www.tubebuddy.com/bas 🏄 Stuff I use daily https://amzn.to/3HqfMQ2 * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos! Thanks for being a part of this channel and all your support! 💪 🙏 #HowToPowerBI​ #PowerBI​ #DataTraining​ #powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX