I will receive actual every month (Screenshot1), however I must consider only till last month (i.e Month(now)-1) which should be dynamic. Also I will receive forecast (as in Screenshot2)
Requirement is in last screenshot. Till P01 to P04 Actual Data(40) and from P05 to P12 forecast Data(60) and finally total of Actual and forecast(100).
Actual Data every month will be updatedForecast Data every month will be reduced month by month till it reaches P12required output in Power BI
I have wrote DAX Measures, however its not showing correct output. I'm not sure where is my logic need to be changed, As its calculating both Actual and forecast(102) or calculating only Forecast(60). Its not giving 100