Forum Discussion

morther's avatar
morther
Icon for Helper I rankHelper I
9 years ago
Solved

Duplicate column to a related table

  I have 2 tables, "Nodes" and "ImportCubicPMs"  They are joined from Device_ID to NodeName.    In the table "ImportCubicPMs" there is a column "PM Count" which I would like to duplicate to ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi morther,

     

    The RELATED function works on the Many side between the related tables. But you're creating the column on the One side(Nodes table), so it won't work here.

     

    In your scenario, you should be able to simply use the formula below to create a column in the "Nodes" to get "PM Count" from the table "ImportCubicPMs". :smileyhappy:

    PM = CALCULATE ( SUM ( ImportCubicPMs[PM Count] ) )

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi morther,

 

The RELATED function works on the Many side between the related tables. But you're creating the column on the One side(Nodes table), so it won't work here.

 

In your scenario, you should be able to simply use the formula below to create a column in the "Nodes" to get "PM Count" from the table "ImportCubicPMs". :smileyhappy:

PM = CALCULATE ( SUM ( ImportCubicPMs[PM Count] ) )

 

Regards

  • morther's avatar
    morther
    Icon for Helper I rankHelper I
    9 years ago

    That worked like a charm.  Thank you so much