cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Average 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. 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

Matt

2 REPLIES 2
Microsoft Employee

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

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

Matt

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.