Forum Discussion
undefined
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.
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?
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.