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.
I have two different columns
In the first: Date
For example: 19.06.2018
In the second: Time
For example: 09:49:40
For my analysis I need the following in one collum: 19.06.2018 09:49:40
Can someone help me and tell me how can I combine these two collums?
Solved! Go to Solution.
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]
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]
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |