Monthly data in different tables

[gabipfranceschi]

Hi everyone.

New user here, hope you can help me.

The telephone service at my company provides all of the call's informations in .csv files, that get constantly updated for every new call, in or out, internal or external.

I've already been able to do all of the monthly reports, but I'm having some trouble with the yearly report, since I have 1 diferent .csv file for every month.

How do I properly relate the files so I can have for example the number of calls every operator managed to answer each month?

Thanks a lot for any help!

Regards from Brasil.

[v-juanli-msft]

Hi @gabipfranceschi 

Besides these supposed solutions, you need to create a date table.

If you have any problem, share some example for further analysis.

Best Regards

Maggie

[camargos88 · Accepted solution]

Hi @gabipfranceschi ,

Check this link: https://powerpivotpro.com/2016/12/import-csv-files-folder-filenames-power-bi/

As @Greg_Deckler  said, you can connect them using folder connector.

Ricardo

[Greg_Deckler]

Append them all into a single query using an Append query. Or, use a Folder query. I would use a Folder query.