Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have looked throughout this forum and other online resources and I cannot find an example with my criteria. I would like to convert the following text column into MM/DD/YYYY date value.
The difference between what I was able to research was this has "APR 1, 2018 timestamp" vs "04/01/2018 timestamp."
Thank you!
Solved! Go to Solution.
Here is an example how you could achieve this in Query Editor:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WciwoUjDUUTAyMLRQMLQyNLAyNFNw9FUIcAlRio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5", "Column1.6"}), #"Inserted Merged Column" = Table.AddColumn(#"Split Column by Delimiter", "Merged", each Text.Combine({[Column1.1], Text.From([Column1.2], "en-US"), Text.From([Column1.3], "en-US")}, " "), type text), #"Changed Type" = Table.TransformColumnTypes(#"Inserted Merged Column",{{"Merged", type date}}), #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Merged"}) in #"Removed Other Columns"
Here is an example how you could achieve this in Query Editor:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WciwoUjDUUTAyMLRQMLQyNLAyNFNw9FUIcAlRio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5", "Column1.6"}), #"Inserted Merged Column" = Table.AddColumn(#"Split Column by Delimiter", "Merged", each Text.Combine({[Column1.1], Text.From([Column1.2], "en-US"), Text.From([Column1.3], "en-US")}, " "), type text), #"Changed Type" = Table.TransformColumnTypes(#"Inserted Merged Column",{{"Merged", type date}}), #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Merged"}) in #"Removed Other Columns"
Thanks. Pretty new to Power BI and didn't realize there was a "Text to Column" like option in the query editor.