PBIX file “Staffing Demo” contains records for 3 staff members for two weeks - 2020-01-06 and 2020-01-13. Columns are “Date”, “Userid”, “Type”, “Organization”.
Excel file “Staffing - 2020-01-21.xlsx” contains records for 4 staff members - with all the same columns as the PBIX file except “Date”.
Goal is to determine the max date from the PBIX file (2020-01-13), add 7 days to it (2020-01-21), import the Excel data, add a column “Date”, populate “Date” with “2020-01-21”, and lastly to append the new Excel records with the date value into the main PBIX file.
Files attached, and thanks