Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have one time column with different times. For example: 12:43:00 and 14:12:00.
I want a second column like this:
Column1 Column2
12:43:00 12-13
14:12:00 14-15
I cant find the formula for this.
Solved! Go to Solution.
In Power Query add a custom column
This solution works! So please click accept solution and thumbs up button
= Table.AddColumn(#"Changed Type", "Custom", each Text.From( Time.Hour([Time]))
& "-" &
Text.From(Time.Hour([Time])+1))
You can pad values before 12 with a leading zero like like
= Table.AddColumn(#"Changed Type", "Custom", each Text.PadStart(Text.From(Time.Hour([Time])),2,"0")
& "-" &
Text.PadStart(Text.From(Time.Hour([Time])+1),2,"0"))
try this
In Power Query add a custom column
This solution works! So please click accept solution and thumbs up button
= Table.AddColumn(#"Changed Type", "Custom", each Text.From( Time.Hour([Time]))
& "-" &
Text.From(Time.Hour([Time])+1))
User | Count |
---|---|
84 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |