topic How to transform a Power BI date column by range in DAX Commands and Tips

How to transform a Power BI date column by range

rsderby68 — Wed, 19 Oct 2022 18:02:52 GMT

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.

Re: How to transform a Power BI date column by range

Stachu — Wed, 19 Oct 2022 19:43:32 GMT

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

Re: How to transform a Power BI date column by range

rsderby68 — Wed, 19 Oct 2022 19:59:00 GMT

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!

Re: How to transform a Power BI date column by range

rsderby68 — Wed, 19 Oct 2022 19:59:22 GMT

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!

Re: How to transform a Power BI date column by range

Stachu — Thu, 20 Oct 2022 18:08:45 GMT

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