cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Qotsa
Helper IV
Helper IV

Replace values in one column based on date range from another

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.

 

1 ACCEPTED SOLUTION
ziying35
Impactful Individual
Impactful Individual

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"} 
     )

 

View solution in original post

2 REPLIES 2
ziying35
Impactful Individual
Impactful Individual

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"} 
     )

 

View solution in original post

@ziying35 

Thank you for this.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors