time and date column in one

Hi Anonymous 

You can use Transform > Merge Columns in Query editor, below is the M code and attached file with example.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMrTUMzDTMzIwtFDSUTKwtDIBIgOl2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [date = _t, time = _t]),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(Source, {{"date", type text}, {"time", type text}}, "en-GB"),{"date", "time"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"datetime"),
    #"Changed Type" = Table.TransformColumnTypes(#"Merged Columns",{{"datetime", type datetime}})
in
    #"Changed Type"

Or add a column with DAX expression.

datetime = 'Table DAX'[date] + 'Table DAX'[time]

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.