Forum Discussion

Tooba_kazmi's avatar
Tooba_kazmi
Helper I
3 years ago

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.

Need Help

3 Replies

    • Tooba_kazmi's avatar
      Tooba_kazmi
      Helper I
      3 years ago

      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's avatar
        v-jianboli-msft
        Community Support
        3 years ago

        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.