How to associate specific columns with dates when loading data?

[korwwyn]

Hi, I have a list of excel files. Each of them contains the following data.

• Questions
• dd.mm.yyyy
• Customer name
• Answer
• Comment

Questions are the same, but columns "Customer name", "Answer" and "Comment" are repeated, and they are related to the dd.mm.yyyy column.

All I want is to associate columns "Customer name", "Answer" and "Comment" with the dd.mm.yyyy columns. Right now I just have columns dd.mm.yyyy_1, customer name_1, ....

As a result, I want to remain only 3 columns, that are associated with the different dates.

Sorry if it is not understandable. I would be grateful if you could give me some direction.

[Hariharan_R]

Hi,

I hope you are using Folder as a data source where you are pointing the folder path.

In a easy way, maintain the name of the column is same acorss all the files. 

Ref - https://sqlitybi.com/loading-multiple-excel-files-from-a-folder-in-power-bi/

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[korwwyn]

Thanks for your response. Yes, I'm using folders as a source. 

I have lots of excel files, but the structure inside is the same. It looks like that:

But I want to gather all that data and create beautiful graphs in PowerBi. But I'm stuck with associating specific answers to specific dates..