Forum Discussion
Convert Date/time/timezone field to duration.
I am trying to convert this data type to duration but I get an error. Is there a workaround for this?
Anonymous just make sure that your column is Text format before you run the Custom Colum:
The first column above is the ABC text based duration.
The next step, add Custom Column with the above code.
Third step, convert new column to duration.
TheoC
Community Champion
Community ChampionAnonymous just make sure that your column is Text format before you run the Custom Colum:
The first column above is the ABC text based duration.
The next step, add Custom Column with the above code.
Third step, convert new column to duration.
Do these steps have to be done in the transform data power query editor?
- TheoC
Yeah, correct! In Power Query 🙂