How to transform a Power BI date column by range

[rsderby68]

Would someone give me a hand here? Still learning Power BI transformations. 

I have a column called created_at that has dates in format of ISO 8601 format YYYY-MM-DDTHH:MM:SSZ (Date/Time/TimeZone).  I want to transform that column so that every value that is before 05/15/2022 is changed TO 05/15/2022 otherwise, leave the value the same.  So the column should only have dates listed as 05/15/2022 or later.  

[Stachu · Accepted solution]

assuming the previous step name is "#Changed Type"

= Table.TransformColumns(#"Changed Type",{{"created_at", each List.Max({_,#datetimezone(2022,5,15,0,0,0,0,0)}), type datetimezone}})

you can adjust time zone with the last 2 parameters of #datetimezone

[rsderby68]

Forgive my blankness but would you clarify what the "previous step name is "#Changed Type"" is for?  Is "Changed Type" the original column name you mean?  

Thanks for the formula I will try it! 

[Stachu · Accepted solution]

assuming the previous step name is "#Changed Type"

= Table.TransformColumns(#"Changed Type",{{"created_at", each List.Max({_,#datetimezone(2022,5,15,0,0,0,0,0)}), type datetimezone}})

you can adjust time zone with the last 2 parameters of #datetimezone

[rsderby68]

Forgive my blankness but would you clarify what the "previous step name is "#Changed Type"" is for?  Is "Changed Type" the original column name you mean?  

Thanks for the formula I will try it! 

[Stachu · Accepted solution]

In the Transform data mode, one you enable Query Settings in the View ribbon, you will be able to see the transformation steps in each table, the code I posted assumes that the previous step is called "#Changed Type" as in the picture below