Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Union only selected columns in new table

Hi there   I have two tables - Table1 and Table 2. Both hold columns called [User ID] and [User Name]. I want to create a dim table holding unique values of these two columns.   I could use the ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    maybe you can try

    Table 2 = UNION(SUMMARIZE('Table','Table'[userid],'Table'[username]),SUMMARIZE('Table (2)','Table (2)'[userid],'Table (2)'[username]))

     

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

Anonymous 

maybe you can try

Table 2 = UNION(SUMMARIZE('Table','Table'[userid],'Table'[username]),SUMMARIZE('Table (2)','Table (2)'[userid],'Table (2)'[username]))

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks Ryan this worked perfectly. I will adopt this in future now for Dim Tables 🙂 

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    you are welcome.