Forum Discussion
Create phasing table from campaign forecasts
Hi Mrdavew ,
Agree with PwerQueryKees 's approach and expand on it:
1. First create a new table:
Calendar = CALENDAR(MIN('Table'[Start Date]),MAX('Table'[End Date]))And the relationship:
2. Then pelase create a new measure like:
Measure = VAR __cur_date = SELECTEDVALUE('Calendar'[Date]) VAR __result = CALCULATE(SUM('Table'[Daily Sales]), 'Table'[Start Date]<=__cur_date && 'Table'[End Date]>=__cur_date) RETURN __result3. Next please create a line chart and open forecast:
Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi Mrdavew ,
Agree with PwerQueryKees 's approach and expand on it:
1. First create a new table:
Calendar = CALENDAR(MIN('Table'[Start Date]),MAX('Table'[End Date]))And the relationship:
2. Then pelase create a new measure like:
Measure =
VAR __cur_date = SELECTEDVALUE('Calendar'[Date])
VAR __result = CALCULATE(SUM('Table'[Daily Sales]), 'Table'[Start Date]<=__cur_date && 'Table'[End Date]>=__cur_date)
RETURN
__result
3. Next please create a line chart and open forecast:
Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thank you so much. This has worked beautifully. Your extra level of detail really helped.
This was my first stage to solve for a flat daily forecast, in reality the forecast is biased left or right. i.e customers rush in and buy as soon as the promotion launches, or they buy towards the end as they see its about to finish. So now I need to figure that out!
