Accruing values weekly

Hi Jeff2Jets ,

To make this automatic, create a new folder where you will place the .csv files.

And in excel instead of importing the single file every time, you can import a folder directly. please follow these steps.

1- Go to Power query > New Source > More

2- Now go to All > Folder and click connect

3- Now browse the folder and click ok:

4- Now click Combine & Transform Data:

5- Select the week1 and click ok:

6-  Delete the Source.Name column

7- Now lets split the column by delimiter (considering that the values are in one column separated by comma):

8- Now split by comma for each occurence and click ok:

Now my table look like this:

Check that my columns headers are in the first row and in the 4 row, lets correct this:

9- Now use the first row as header:

10- Now drop down the filter in Employee name column and uncheck the Employee name, this will ensure to hide all row containing this name:

Now my table look like this:

Now follow the steps from 3 till the end to group # of calls from my previous repply.

Note: The table names (name of sheets) of your .csv should be exactly the same for all files.

Now for new weeks, you just need to place the file in created folder and go to power bi and refresh to ensure that the new data is loaded.