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!
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.
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
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
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
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.
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
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
Thank you - got this working in like 15 minutes and would have spent hours trying to figure it out.
This really helped me. Thanks!
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!
Thank you
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.
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
Thanks for more great tips. What if we wanted to measure our forecasting ability to actual sales?
This is fantastic❤ can you also make a video for accumulated actual and forecast in one line?
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
Another great video!
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
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.
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
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
Um...why are we using MAX function?
Is there a way to do this for cumulative?
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
But it's not explained how to create the Forecast measure