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 support@datatraining.io
---------------------------------
⏱️ 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
Видео What's the missing LINK?! Combining ACTUALS and FORECAST as one LINE in Power BI канала How to Power BI
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 support@datatraining.io
---------------------------------
⏱️ 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
Видео What's the missing LINK?! Combining ACTUALS and FORECAST as one LINE in Power BI канала How to Power BI
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Dare to Say NO! #powerbi #shorts](https://i.ytimg.com/vi/-Ipmy_JDufs/default.jpg)
![Power BI Report Makeover Example](https://i.ytimg.com/vi/o7t1-NK98kY/default.jpg)
![MAP LOCATIONS in Power BI #Shorts](https://i.ytimg.com/vi/0OIRMjbMU6U/default.jpg)
![Apply a DYNAMIC FILTER to your report with the PLAY AXIS | Report Animation in Power BI](https://i.ytimg.com/vi/NYp6UnJ-zY0/default.jpg)
![Power BI Practice Solution ROUND #5 I Pivoting in Power Query and what to do if it doesn't work](https://i.ytimg.com/vi/E1TDpgDPbks/default.jpg)
![Calculate OPEN CASES over time in Power BI | Part 2](https://i.ytimg.com/vi/7_kAJ7wSwJk/default.jpg)
![Checkmark SLICER You Have Not Seen Before | Power BI](https://i.ytimg.com/vi/9NMJSBWcGfM/default.jpg)
![THE BEST way to add IMAGES from OneDrive & SharePoint in Power BI](https://i.ytimg.com/vi/BxcHdwF7_1s/default.jpg)
![This ONE IDEA opens ENDLESS POSSIBILITIES | Combining Reference Lines and Parameters in Power BI](https://i.ytimg.com/vi/9TyKMEoUMy0/default.jpg)
![Set Up Automatic KPI Trackers | Dynamic Alerts in Power BI Desktop](https://i.ytimg.com/vi/RyEQ9n9ails/default.jpg)
![SMART AXIS Magic | Let Power BI Choose the OPTIMAL Period](https://i.ytimg.com/vi/KReYWx5NXYg/default.jpg)
![UX Revolution with Visual Level PAGINATION in Power BI](https://i.ytimg.com/vi/TiS6vnju_mI/default.jpg)
![BOX PLOT.... what?! When and why is it useful? #powerbi #datatraining](https://i.ytimg.com/vi/ByoWRZMS0OA/default.jpg)
![Color INDICATORS in Power BI I ADD Formatting Options #shorts #powerbi](https://i.ytimg.com/vi/TVTxs_nEZPE/default.jpg)
![Write Your First CUSTOM M FUNCTION in Power BI](https://i.ytimg.com/vi/Ws-xncVlKFg/default.jpg)
![PUSH the limits of Power BI native VISUALS and CAPTIVATE your audience | TIMELINE chart Step-by-Step](https://i.ytimg.com/vi/cVy6rQMcmkg/default.jpg)
![SUPERCHARGE VISUALS in Power BI | Add KPIs to Titles](https://i.ytimg.com/vi/qumRCVLjcIo/default.jpg)
![WHAT IF PARAMETERS in Power BI I Forecasting Power BI Search Trends in 2021](https://i.ytimg.com/vi/QXNRseW0R7E/default.jpg)
![HOVER EFFECT that will WOW end users? See how to INSTANTLY upgrade your PAGE NAVIGATION in Power BI!](https://i.ytimg.com/vi/574qoTsCEGU/default.jpg)
![I Changed My Mind About GIFS | Animated Images in Power BI](https://i.ytimg.com/vi/oIUne5vaje4/default.jpg)
![The ULTIMATE Page Navigation (Part 3) What you DON'T KNOW about SHADOW & GLOW I Power BI DESIGN](https://i.ytimg.com/vi/b3dhwII31VA/default.jpg)