cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brownmattc Frequent Visitor
Frequent 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

InvoiceDateInvoiceAmount
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

2 REPLIES 2
brownmattc Frequent Visitor
Frequent Visitor

Average Spend by Month with Forcasting

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

InvoiceDateInvoiceAmount
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

Moderator v-yuezhe-msft
Moderator

Re: Average Monthly Spend and Forecast

@brownmattc,

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.
1.JPG


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.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors