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.

amitchandak's avatar
amitchandak
Super User
6 years ago

Try union and Summarize

 

Sheet = union(SUMMARIZE(Sales,Sales[Brand]),SUMMARIZE(Sales,Sales[Brand1]))

 

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks