Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am new into PowerBi and I am wondering if it possible to union different tables with same fields but different number of columns. As some tables have additional fields. I know that it is possible in Tableau. Is this possible in PowerBI? If so someone can help me with this?
Thank you
Solved! Go to Solution.
@Anonymous
It doesn't allow you to union two tables with different number of columns, however, if you can use SELECTCOLUMNS to select the required column to union the tables like:
New Table=
UNION(
SELECTCOLUMNS('Table1',"Col1",'Table'[Column1], "Col2",'Table'[Column1]),
SELECTCOLUMNS('Table2',"Col1",'Table2'[Column1], "Col2",'Table'[Column2]),
)
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
The code that I shared is to create a table, you can go to Modeling Tab, > New Table and Past the code below:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
It doesn't allow you to union two tables with different number of columns, however, if you can use SELECTCOLUMNS to select the required column to union the tables like:
New Table=
UNION(
SELECTCOLUMNS('Table1',"Col1",'Table'[Column1], "Col2",'Table'[Column1]),
SELECTCOLUMNS('Table2',"Col1",'Table2'[Column1], "Col2",'Table'[Column2]),
)
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi,
I have created the following DAX expression:
However, I get this error message:
'The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.'
How can I fix this?
@Anonymous
The code that I shared is to create a table, you can go to Modeling Tab, > New Table and Past the code below:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you for your help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
20 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |