Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Folks.
Trying to do the following:
- search for column headers ending with '_time'
- duplicate, or AddColumns, column and change type.
existing table
table after change
Thank you in advance...
Solved! Go to Solution.
it will be easier to process this in PowerQuery
NewStep=Table.FromRecords(Table.TransformRows(PreviousStepName,each Record.TransformFields(_,List.Transform(List.Select(Record.FieldNames(_),each Text.EndsWith(_,"_time")),(x)=>{x&"_copy",(y)=>Time.From(Record.Field(_,x))}),2)))
it will be easier to process this in PowerQuery
NewStep=Table.FromRecords(Table.TransformRows(PreviousStepName,each Record.TransformFields(_,List.Transform(List.Select(Record.FieldNames(_),each Text.EndsWith(_,"_time")),(x)=>{x&"_copy",(y)=>Time.From(Record.Field(_,x))}),2)))
Thank you very much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
27 | |
23 | |
15 | |
11 |
User | Count |
---|---|
76 | |
58 | |
46 | |
17 | |
12 |