Forum Discussion

brownmattc's avatar
brownmattc
Icon for Advocate II rankAdvocate II
8 years ago

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. Fin...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.


For your second question, could you please explain the logic you use to calculate the forecast?


Regards,
Lydia