PowerBI Budget Multiple Year Context

[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…