Create a new table from columns from existing tables

Question

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 other tables.

So, I have

Item No (Item Table)

Quantity (Production)

Price (Production)

Hours (Job)

Price (Job)

And I want to summarize the totals for each item in a single table. I've been looking at videos and help but I can't find anything which actually tells me here is how you do whatever it is i'm supposed to do here. There is some additional filtering to be done by Posting Date for the Production and Job tables.

anonymous · Answer

Search for UNION.&nbsp;&nbsp;The UNION function is needed and SELECTCOLUMNS function within it.&nbsp;&nbsp;The SELECTCOLUMNS function is used in front of every new table to address.&nbsp;&nbsp;These will get you started. The SELECTCOLUMNS is easy to mess up. patience!&nbsp;&nbsp;UNION:&nbsp;&nbsp;https://msdn.microsoft.com/en-us/query-bi/dax/union-function-dax&nbsp;SELECTCOLUMNS:&nbsp;https://msdn.microsoft.com/en-us/query-bi/dax/selectcolumns-function-dax&nbsp;Cheers!

pcowman · Answer

Thanks, I'll take a look at those.&nbsp;

pcowman · Answer

Not 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.

Forum Discussion

Create a new table from columns from existing tables

3 Replies

Related content

Create columns group

Create a new table from columns from existing tables

Create new column from existing columns

column deleted but column exists

Cannot create liquid clustering on existing unpartitioned table