I have two facts table, one for “Actuals” and one for “Budget”. Now, I want to create a “Reforecast” calculation which will take the YTD figures and adds the remainder of the year to it to create a full year Reforecast. So, as an example, we are now in May 2019. I would like to see the Reforecast total as actuals Jan - May 2019 PLUS budgeted June - December 2019.
As my budget is on a monthly basis and the figures differ month on month, I cannot use the total divided by 12 and instead want the exact numbers.
My question is, using the same example, how do I create a dynamic Dax which pulls the total of reamining months based on the selected month?