Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a custom column

Hello, I'm a new Power BI user and need some assistance in merging columns. This is the excel data input:   I want to create a matrix in Power BI that takes the names from both columns A a...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Based on your description, I suggest you to use DAX Union function to create a calculated table. See Below:

    This is the imported Excel Table named “Sheet1”:

    This is the DAX formula:

     

    Table =
UNION (
    SUMMARIZE ( Sheet1, Sheet1[Column 1] ),
    SUMMARIZE ( Sheet1, Sheet1[Column 2] )
)

     

    This is the Return:

     

    Best Regards,

    Paul Zheng

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous you can add new column in your table and concatenate your columns

 

Name A and B = 
Table[Column A] & " " & Table[Column B]

 

Hope this is what you are looking for.