topic Update column based on matching in DAX Commands and Tips

Update column based on matching

stribor45 — Mon, 27 Nov 2023 19:52:44 GMT

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.

Re: Update column based on matching

WinterMist — Mon, 27 Nov 2023 21:49:10 GMT

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

Re: Update column based on matching

stribor45 — Mon, 27 Nov 2023 22:41:14 GMT

yes i do want to change the date

Re: Update column based on matching

WinterMist — Mon, 27 Nov 2023 22:43:22 GMT

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.