Forum Discussion
Interfacing headers names
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,
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!
2 Replies
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!