Replace values in one column based on date range from another

[Qotsa]

Hi,

Looking to replace all values 'X1' in column A with values 'X2' using M language. Can't duplicate column A.

Condition is that only replace the values for date range between 01/01/20 to 06/06/20 using column 'Date' in same table.

[ziying35 · Accepted solution]

Hi, @Qotsa 

try the code below:

= Table.ReplaceValue(
          YouPreviousStepName, 
          each [Date]>=#date(2020, 01, 01) and  [Date]<=#date(2020, 06, 06), 
          each [column A]="X1", 
          (x,y,z)=>if y and z then "X2" else x, 
          {"column A"} 
     )

[Qotsa]

@ziying35 

Thank you for this.