Forum Discussion

Icon for Responsive Resident rank

Responsive Resident

6 years ago

Add weekly data

Hi, Please download 3 sample excels file from here: FILE DOWNLOAD Week1 file is the main file and I want to merge (not aggregate) all the records from other weeks (week2 and 3) into Week1. ...

Icon for Super User rank

Super User

6 years ago

mb0307 , I have discussed here how to convert week to date

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3

For data merge

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4bff711

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/

https://radacad.com/append-vs-merge-in-power-bi-and-power-query