undefined

[Tooba_kazmi]

How do i create a new table with multiple calculated columns taken from a different table? Its just like a copy and past from one table to another but I'm unable to do it.

[amitchandak]

@Tooba_kazmi , Power query merge

Merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Or copy a column from one table to another

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[Tooba_kazmi]

But I have multiple calculated columns in two different tables that i am trying to join in a new table. Since they are calculated columns there are not being shown in power query. 

I've tried to get the columns from one table into a new one using Summarize function but it doesn't give the desired result. 

PoliciesfromPriceEstimate = SUMMARIZE(FILTER('Price Estimates','Price Estimates'[Policy] <> Blank()),'Price Estimates'[Week Ending],'Price Estimates'[Policy],'Price Estimates'[Branch], 'Price Estimates'[LAM],'Price Estimates'[All States]). 

All the above cols are calculated.  Once I have the desired result,i can use Union to append them but how to filter out these columns into new ones?

[v-jianboli-msft]

Hi @Tooba_kazmi ,

Based on your description, I have created a simple sample:

Please try:

Table 2 =
ADDCOLUMNS (
    'Table',
    "V22",
        CALCULATE (
            SUM ( 'Table (2)'[V22] ),
            FILTER ( 'Table (2)', [ID] = EARLIER ( 'Table'[ID] ) )
        ),
    "V3",
        CALCULATE (
            SUM ( 'Table (3)'[V3] ),
            FILTER ( 'Table (3)', [ID] = EARLIER ( 'Table'[ID] ) )
        )
)

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.