Interfacing headers names

[Anonymous]

Hi, 

I am working on a PBI soucred on a data.csv file which might change in format in the upcomming. Is it possible in Power BI to first merge columns with similar headers ?

For instance, in this csv file, a new columns "offres" may appear instead of "offre" as below :

 

I would like to set up an interface where I can say : If a header is "offres", "Offre" or "ofre" then merge it with "offre". It would result in : 

Is that possible in PBI ?

Thanks in advance,

[Tahreem24 · Accepted solution]

Hi @Anonymous ,

Please follow the below Steps: (Attached screen shot for your reference)

Step 1: Go to Power Query Editor.

Step 2: Go to  Add Column option --> select Custom Column Option --> Enter Name of your Column and expression as "[Offres]+[Offre]+[Ofre]".

Step 3: Hit Ok and you will get your expected out put.

Output:

Please give KUDOS to my effort and accept this as a solution!

[Anonymous]

Thanks for the job done. 

But this solution does not work as my colums "offres" & "Offre" don't exist yet. It gives me this error: