Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Input Multiple Excel sheets to capture historical data in Power BI

My customer gives me the below requirement for employees work timesheet dashbaord. There is a shared path location in which they will be placing an excel sheet every week. The excel sheet will be...

amitchandak
5 years ago
Anonymous , As per what I got. You need 2 things

You can get date based on sheet name

https://community.powerbi.com/t5/Desktop/Add-custom-column-with-sheet-name/m-p/877507

You can also check this DAX append method to add new data

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://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

Super User

5 years ago

Anonymous , As per what I got. You need 2 things

You can get date based on sheet name

https://community.powerbi.com/t5/Desktop/Add-custom-column-with-sheet-name/m-p/877507

You can also check this DAX append method to add new data

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://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/