Forum

How can I replace v...
 
Notifications
Clear all

How can I replace values from a Table?

2 Posts
2 Users
0 Reactions
81 Views
(@jycccwjc)
Posts: 64
Estimable Member
Topic starter
 

I can replace values with specific replacements such as the one below:

replace "06/07" with "W"

and 

replace "06/08" with "Th"

#"Replaced Value7" = Table.ReplaceValue(#"Expanded WkNum","06/07, 06/08","W, Th",Replacer.ReplaceText,{"meeting_dates"}),

 

My question is:

How can I replace values with a specific list (or a table) using two columns, dates & weekdays? Please refer to the attachment.

 

Thanks!Repalce-specific-dates-with-weekdays.PNG

 
Posted : 09/07/2023 9:57 pm
(@catalinb)
Posts: 1937
Member Admin
 

You can try this solution.

 
Posted : 09/07/2023 11:33 pm
Share: