Forum Discussion
Forecasting Expenses
I am fairly new with Power BI, but hoping I get some help here. I have started using Power BI for monthly expense reporting for a large manufacturer. I am now wanting to pivot and begin using Power BI to project current month as well as future months/quarters/full year expenses. To do this, I need to be able to layer in actuals for MTD/QTD/YTD. In addition, I need to layer in where the period is projected to finish. For example, if I have $7,000 in Supplies expenses mid-way through the month, I would anticipate finishing around $14,000. I need to be able to have full P&L expenses included, but be able to drill in to a bottom GL level. For some of the expense lines, the full expense comes in a month-end entry, so a trend based on current expense amounts mid-period would not work. So I would need to include the ability to use trend for some expense lines, and a 'projected' amount for others. Can anyone help point me in the best direction to do this efficiently?
1 Reply
- AnonymousNot applicable
Hi Anonymous ,
Is there no date column in your table? What's your data structure or model? I can do nothing based on your screenshot because the information you have provided is not making the problem clear to me. You just give me the value between July to April, so I cannot evaluate the YTD without the value of this year.(Jan - Apr)
Could you please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you.
You can save your files in some cloud sharing platforms and share the link here.
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Yuna