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