Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

Importing three columns under one heading

Hi there,

 

I am getting data from excel. There are three columns under one heading or field.

I want to see all 3 column data.

 

ACCOUNT NUMBER
A000111999111
A555777444111

 

When I select ACCOUNT on the dashoboad table , it displays only A.

 

Thanks for your help. 

Need Help
  • sdhn's avatar
    sdhn
    5 years ago

    Can we merge 3 columns onto one column at Power Bi desktop?

     

    This will solve the issue.

    It comes as Account , Column 1, Column 2.

     

    I want to make all 3 column under one heading.   Thanks 

     

3 Replies

  • sdhn's avatar
    sdhn
    Icon for Responsive Resident rankResponsive Resident
    5 years ago

    Can we merge 3 columns onto one column at Power Bi desktop?

     

    This will solve the issue.

    It comes as Account , Column 1, Column 2.

     

    I want to make all 3 column under one heading.   Thanks 

     

    • HashamNiaz's avatar
      HashamNiaz
      Icon for Solution Sage rankSolution Sage
      5 years ago

      Hi sdhn !

      Yes, you ca do this in Power Query. Go to Transofrm Data -> Transform, select all 3 columns of perform Merge tranformation.

       

      Merge

       

      Regards,

      Hasham

  • HashamNiaz's avatar
    HashamNiaz
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Hi sdhn !

    You can use following DAX to create a New Column which can be used to reprsent concanated Account Number;

     

    AccountNumber = 'Table'[ACCOUNT NUMBER] & RIGHT("000000" & 'Table'[Col1], 6) & RIGHT("000000" & 'Table'[Col2], 6)

     

    Hope this will solve your issue.

     

    Regards,

    Hasham