Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Every two weeks we capture forecasted revenue to determine accuracy but we also use it to forecast out until end of year. I am looking for a formula that calculates a projected revenue for any date that is not yet captured by finding the last record value and multiplying it by 1.035 and to continue to apply it to all rows. This is very easy to do in excel but I cannot wrap my head around it in power bi.
I have two tables 'Forecast Calendar' with [Date]. I have a 'Forecast Audit' table that has the [Date] & [Projected Revenue]. I added index columns to both thinking this may lead me in the right direction. I also merged the tables in power query.
dataset: https://docs.google.com/spreadsheets/d/1Xghbz_vf8VXOcMJCT2zFZu1ekpnLhzQvG4cSDsfBDEE/edit?usp=sharing
here is a snippet as well.
Expected results (highlighted yellow. I want it to show the actual $$ value but wanted to show the excel formula I would use if in excel)
*ignore the date format
Solved! Go to Solution.
Hi,
Share the download link of the file with the 2 original tables (not the one you merged in Power Query)
I need it to be accumulating so I need 4/12 date to be (53,360,016.83 * 1.5) and so on. Here are the values I am looking for. Thank you for taking the time to help!
Thank you so much this worked perfectly!!
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |