Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
2 years ago
Solved

Update column based on matching

Part of my code looks  like this   SWITCH ( TRUE (), COUNTROWS( FILTER ('Table_A', 'Table_A'[Agent ID/EMPLID] = 'Table_B'[Agent Number] && 'Table_A'[First Name] = '...
Help
  • WinterMist's avatar
    WinterMist
    2 years ago

    OK, yeah.  Maybe someone can correct my understanding if I'm wrong.

     

    But as far as I am aware, you can't change source model data with measures or calculated columns.

    Only way I know to do it is in the source system itself or in Power Query.

WinterMist's avatar
WinterMist
Impactful Individual
2 years ago

stribor45 

 

When you say "update one of the columns in Table B", it sounds like you are wanting to actually change the data itself.  Is that right?

 

This cannot be done with a measure, or even a calculated column.

I could be mistaken, but I believe the only way to alter data is either in the data source itself or in Power Query.

 

Let me know if I'm confused about what you are asking.

 

Regards,

Nathan