Forum Discussion
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] = '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.
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.
3 Replies
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.
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
yes i do want to change the date
