I have used the quick measure to calculate a 12 month rolling average for my data. This all works fine. However, PowerBI appears to have forecast the rolling average past my last data point. So the last data point I have in the time series is February 2019, but the rolling average has been calculated until December 2019.
Can anyone tell me how PowerBI is calculating these extra values? and why it is calculating them? and how to stop it?
I've tried working it out from the DAX and got nowhere!