Update column based on matching

[stribor45]

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] = 'Table_B'[Agent First Name] &&
                        'Table_A'[Last Name] = 'Table_B'[Agent Last Name] &&
                        'Table_A'[Birthdate] = 'Table_B'[Date Of Birth]
             )) > 0 , "Found",

Is there a way to update one of the columns in Table B based on what row was match found? So if the match was found in row 2 then column in Table B second row should be updated. I was hoping to do this in DAX instead of PQ.

[WinterMist · Accepted solution]

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.

[stribor45]

yes i do want to change the date

[WinterMist]

@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