Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. 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
Create a table visual as shown in the following screenshot, choose “Average” for InvoiceAmount, you will get average amount spent per month for each year.
For your second question, could you please explain the logic you use to calculate the forecast?
Regards,
Lydia
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. 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |