Forum Discussion
Creating a forecasting plot that only returns values for the previous month and onward
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thank you for the response, below are samples of my data tables!
BudgetDate:
| Date | Month |
| 01/01/2022 | JAN |
| 03/03/2022 | MAR |
| 04/11/2022 | APR |
| 06/01/2022 | JUN |
tblForcast
| dtForecast | Value |
| Saturday, January 1, 2022 | $971,100 |
| Tuesday, March 3, 2022 | $125,000 |
| Monday, Aprill 11, 2022 | $1,000,000 |
| Wednesday, June 1, 2022 | $4,600,000 |
Desired outcome: Redline only shows data which is past the previous month, and *bonus* light blue line only shows data before the current month. The issue is the red line needs to still have the cumulative data from previous months included as the line is cumulative. Using my sample data, the first point would only appear for April but display a value of $2.1 M or $2,096,000.