Forum Discussion
struggle
Helper II
Helper IICreating custom columns keeps returning a structured Table column
For example, since Power Query isn't able to autoconvert the column Date, which is in yyyymmdd format, into date format, I've been trying to convert it using different custom column calculations, but...
If you are using the UI to add a column you do not need to write "Table.AddColumn". You would only need to write everything you have after the 'each'
jgeddes
Super User
Super UserPower Query will convert that date column to a date format if you specify the culture it needs.
https://learn.microsoft.com/en-ie/powerquery-m/date-from
The Date.From and Date.FromText functions both have that ability.
