Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    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!

Tahreem24's avatar
Tahreem24
Super User
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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: