Good Day all,
I am learning Power BI, my level is really basic and the course I took didn't have any information on my issue nor have been able to find an answer for this browsing in the web.
I've got a data base for actuals & forecast for specific products, I need to run some reports and scorecards concerning that data, see attainment on FCST, Deltas,etc. The issue is that this is not static DB, it is a 24 rolling months data base, so each month, I move one month, for example, if I run it today, it'll start on April 1st on 2018 and end up on april 1st 2020.
I created a master file for the actuals/forecast data to be kept with a relationship with another table to track my products, the structure is pretty simple, it was product column, product ID, product description, column that indicates if it is actuals or forecast, then the 24 months, and that worked really well, but as we just moved to a new month, it is throwing an error stating that column March 2018 is missing and doesn't allow me to refresh.
Is there a way I can setup my data to refresh even if the data base columns have changed? if not, every single month I would be running into this same situation and it would not be lean at all. thoughts anyone?
Regards,
Carlos Ch.
