PowerBI Budget Multiple Year Context

[jsavage]

Hi
I have worked through this video series that explains budgeting over a single year.

Introduction to Budgeting

Im sure there is an example over multiple years however I cant find it in the resources.
I am exploring how to build a budgeting tool for multiple projects with different start dates.
Could someone point me to the resource please?
James

[EnterpriseDNA]

Hi @jsavage , a similar topic was covered in this forum thread link. You might get additional tips here:

Time intelligence fucntion inside Vlookup (need to create the ROW by currency context inside DAX)

Hello, what I’m trying to achieve is getting last year sales (2018) multiply by actual year Budget rate (2019) so I can compare this to Actual year sales at AY budget (2019). I m using Vlookup to get retrieve the currency and the exchange rate. With this formula: Amounttoconvert = SUMX(Entries, Entries[CC amount] * LOOKUPVALUE('Currency rates (BG&FORECAST)'[BG'19 Rates], 'Currency rates (BG&FORECAST)'[Currency I have] , Entries[Company currency], …

How to calculate Year on Year (YoY) Growth?

Hi all - based on spreadsheet below. I have the Sales data for 2019 & 2020 However I do not have the 2021 sales data. I intend to calculate an estimate based on the prior year. I calculated the following measures: Sales LY Sales TY vs LY YoY Sales Growth 2021 Sales Budget (Column E4) should be a calculation of the YoY growth rate multiplied by the Sales LY My question is how do I create a measure for this. An option is to hardcode the number eg Sales Budget = [Sales LY] * 1.44 Howeve…

https://forum.enterprisedna.co/t/creating-budgets-with-seasonality-adjustments-automatically-power-bi-technique/502/10

Compare total services of current week with same period last year

Looking for DAX formula to compare total services of a selected week(s) with last year same period. For example, I like to be able to compare total services (count) of service Week 1 January 2018 with Week 1 January of 2017. Week starts with first of the month + 7. So, week 1=1 thru 7, week 2 = 8 thru 14, week 3 = 15 thru 21, week 4 = 22 thru 28 and week 5 = the rest. I will use the week variable in filter along with service year and month. I have looked at comparing current year or even curren…

[EnterpriseDNA]

Hi @jsavage, we’ve noticed that no response has been received from you since the 18th of January. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

[EnterpriseDNA]

A response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!