Forum Discussion
pcowman
Helper I
8 years agoCreate a new table from columns from existing tables
Hi, I'm trying to get a better look to a report and I'm still learning some of the functions in Power BI so I'm hoping someone can help me out. I want to create a table which summarizes data from...
Anonymous
8 years agoNot applicable
Search for UNION.
The UNION function is needed and SELECTCOLUMNS function within it.
The SELECTCOLUMNS function is used in front of every new table to address.
These will get you started. The SELECTCOLUMNS is easy to mess up. patience!
UNION: https://msdn.microsoft.com/en-us/query-bi/dax/union-function-dax
SELECTCOLUMNS: https://msdn.microsoft.com/en-us/query-bi/dax/selectcolumns-function-dax
Cheers!
pcowman
Helper I
8 years agoNot exactly what I was looking for but a great reference. I've bookmarked it for later use. I'm sure it will come in very handy.