Part of my weekly process involves importing Excel tables into a consolidated PBI table.
The source data does not - of course - include a date stamp.
I’d like to create a process that a) searches the existing PBI consolidated table for the max date; b) adds 7 days to that; c) imports the latest weekly data; d) creates a new column in the new data; e) populates the new column with the +7 date; and e) appends this new data into the consolidated table.
In Excel I’d do most of this with a VBA macro, but I’m not sure what the correct approach in PBI would be.
Thanks in advance for your assistance!