Forum Discussion
brownmattc
Advocate II
8 years agoAverage Monthly Spend and Forecast
Hello, I am new to PowerBI so I could use some assistance: I have a table that contains invoice data with the date received and the amount of the invoice. I would like to do two things: 1. Fin...
brownmattc
Advocate II
8 years agoHello,
I am new to PowerBI so I could use some assistance:
I have a table that contains invoice data with the date received and the amount of the invoice. I would like to do two things:
1. Find the average amount spent per month, year over year (Average of July 2012, July 2013, July 2014).
2. Use these averages to fill in missing data for spending forecasts - As of this writing it is November 2nd. So based on the average Novemeber and December invoice data what is the total expected spend for the year.
Table
| InvoiceDate | InvoiceAmount |
| 07/30/2012 | $2000 |
| 07/30/2012 | $2450 |
| 07/30/2013 | $5000 |
| 07/30/2013 | $6000 |
| 07/30/2014 | $3000 |
| 07/30/2014 | $4000 |
Thank you for any help you can provide,
Matt