https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AddColumns-function-with-criteria/m-p/3053917#M105281 <P>Hi Folks.</P><P>Trying to do the following:</P><P>- search for column headers ending with '_time'</P><P>- duplicate, or AddColumns, column and change type.</P><P>existing table&nbsp;</P><P><img /></P><P>table after change</P><P><img /></P><P>&nbsp;</P><P>Thank you in advance...</P><P>&nbsp;</P> Tue, 31 Jan 2023 23:27:54 GMT aherabit 2023-01-31T23:27:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AddColumns-function-with-criteria/m-p/3053917#M105281 <P>Hi Folks.</P><P>Trying to do the following:</P><P>- search for column headers ending with '_time'</P><P>- duplicate, or AddColumns, column and change type.</P><P>existing table&nbsp;</P><P><img /></P><P>table after change</P><P><img /></P><P>&nbsp;</P><P>Thank you in advance...</P><P>&nbsp;</P> Tue, 31 Jan 2023 23:27:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AddColumns-function-with-criteria/m-p/3053917#M105281 aherabit 2023-01-31T23:27:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AddColumns-function-with-criteria/m-p/3053956#M105286 <P>it will be easier to process this in PowerQuery</P> <P>NewStep=Table.FromRecords(Table.TransformRows(PreviousStepName,each Record.TransformFields(_,List.Transform(List.Select(Record.FieldNames(_),each Text.EndsWith(_,"_time")),(x)=&gt;{x&amp;"_copy",(y)=&gt;Time.From(Record.Field(_,x))}),2)))</P> Wed, 01 Feb 2023 00:16:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AddColumns-function-with-criteria/m-p/3053956#M105286 wdx223_Daniel 2023-02-01T00:16:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AddColumns-function-with-criteria/m-p/3053966#M105289 <P>Thank you very much!</P> Wed, 01 Feb 2023 00:38:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/AddColumns-function-with-criteria/m-p/3053966#M105289 aherabit 2023-02-01T00:38:57Z