Thank you - got this working in like 15 minutes and would have spent hours trying to figure it out.
@goldr0x Жыл бұрын
This really helped me. Thanks!
@jordanmcauley49802 жыл бұрын
I have been trying to figure this out on my own for the last 6 months and then I found this video which solved it in 10 minutes. Sincerely, thank you :) It does create a new issue with the tooltips where when you hover over the historical data it shows both the real and forecasted values (which are the same). Any ideas of how to make it so that the tooltip only shows one value? If not I will just make a custom one. Thanks again!
@gkirankumarskht Жыл бұрын
Hi Fernan., can u please do video on cummulative values of actual and forecast and apply the same logic is not blank. I am trying to do with taking two measures like cummulative actual and cummulative forecast. But max function is not allowing for measure., can u please give me a solution for measures instead of columns
@suziearnold75852 жыл бұрын
Thanks for more great tips. What if we wanted to measure our forecasting ability to actual sales?
@basavarajchiniwalar79757 ай бұрын
Hi, Thank you so much for the video. But I am currently working on with a budget table which has only four columns they are project id, month/year, month and budget. The query is I have a budget value for Jan and Feb. I wanted to forecast the budget value for rest all months. Can you please provide me any solution to perform the task with efficient way. Thanks in advance.
@AlvinRyellPrada2 жыл бұрын
Wow this is so timely thanks Question though, can i do forecast if my historical data is just "month" only.. Not "date"? E. G. Jan 2020 - 10 Feb 2020 - 30 March 2020 - 30 and so on and so forth
@indradutta4136 Жыл бұрын
Hello Fernan, Thanks for demonstrate the logic for showing both actuals & Forecast in the same measure. Can you please show how the forecast measure has been created. Basically I would like to know the logic behind the forecast using DAX, Not the conventional one which is available with in POWER BI.
@SolutionsAbroad Жыл бұрын
Hi there, this video does combine both actuals and forecast, where the forecast measure is already predefined. The one that is calculated is in another video
@philporter4172 жыл бұрын
Another great video!
@flyingeagle3750 Жыл бұрын
Thank you
@kavururajesh17602 жыл бұрын
Hi sir there is any option to send snap shots of the powerbi mutiple screen for multiple companies based on there filter data. Thanks in advance
@SolutionsAbroad2 жыл бұрын
Hi there, there is a new option called "Include my changes" which will allow you to save the filter data: docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards
@OnePercentPerfectionist Жыл бұрын
Um...why are we using MAX function?
@maryampour8914 Жыл бұрын
This is fantastic❤ can you also make a video for accumulated actual and forecast in one line?
@james_msuk10 ай бұрын
Is there a way to do this for cumulative?
@kavururajesh17602 жыл бұрын
In powerbi report we have total 20 screens and all screens are restricted to 1 year data in date filter while sending subscribe Report for weekly can we use same 1 year data report and filter date to 1 week automatically is there any option
@francescomantovani39364 ай бұрын
But it's not explained how to create the Forecast measure