Loading selective months from previous data files

[vishy86]

Hi,

I have a dataset with the Month column which contains data from Jun to Dec 2020. In another file sent, I have the dataset with the same set of columns but for months Apr to Dec 2020 i.e. it contains 2 months extra data for Apr and May as compared to the first file.

File 1 (latest): Jun to Dec 2020 data

File 2: Apr to Dec 2020 data

File 3: Jan to Mar 2020 data

I want to dynamically set up the data load in the Query Editor wherein the latest file i.e. File 1 is loaded completely and in the previous files i.e. File 2 and File 3, only the extra months data is loaded.

In above scenario, I would first like the data from File 1 fully loaded from Jun to Dec 2020.

Then, bring in data from File 2 and only load Apr and May 2020 as File 1 already contains the most recent and updated data from Jun to Dec 2020.

Last, bring in File 3 data but load the complete data as Jan to Mar data is not available previously.

I want to set this up dynamically in the Query Editor. Please note that there is no fixed frequency of producing these data files nor is there any consistency in the number of months of data contained in the file. I understand I can manually do it and remove the months I do not need in the Query Editor but the requirement is to dynamically set this up and possible automate it.

Is this possible in the Query Editor or any other way in Power BI? Please let me know with a sample pbix or so which would be helpful. Thanks.

Regards,

Vishy