Max Month Sales and Budget

[paulwalker]

Hi Community,

I have two tables, Revenue and Budget, I have to calculate MTD for both Revenue and Budget

My Revenue max month November and the budget month is December,
But what is the maximum month in Revenue, the maximum month should show the same even in the budget.

(if it is oct in Revenue, Budget should be OCT value)

Revenue			Budget
MonthYear	Sales		Budget MY	Sales
Jan-21	200		Jan-21	100
Feb-21	300		Feb-21	320
Mar-21	400		Mar-21	540
Apr-21	500		Apr-21	760
May-21	600		May-21	980
Jun-21	700		Jun-21	1200
Jul-21	800		Jul-21	1420
Aug-21	789		Aug-21	1640
Sep-21	235		Sep-21	1860
Oct-21	234		Oct-21	2080
Nov-21	790		Nov-21	2300
			Dec-21	2520

Based on user selection value should be change..

and YTD also should be same..

Thanks in Advance!

[paulwalker]

did anyone face such issue - please let me know.