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.
I created a time signature for how long it took our team to complete a segment within our process. But it has given me a ton of numbers at the end of the duration. This may be a rookie question but for the life of me, I cannot shorten this to be just a normal time signature.
Solved! Go to Solution.
First extract value before the second ".", then transform this column to Duration type again.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
you can use the function of Duration.TotalDays to transform the durations to days.
First extract value before the second ".", then transform this column to Duration type again.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@Ashton_Quincey Try below. Note, I used Colum from examples.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WstQzMLUyNLAysdCzNDM1AAKlWJ1oJQs9I2MrY3MrI0s9QxMjJGEDAyugjImRnqWlMUQ4FgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type duration}}),
#"Inserted Text Before Delimiter" = Table.AddColumn(#"Changed Type", "Text Before Delimiter", each Text.BeforeDelimiter(Text.From([Column1], "en-US"), ".", 1), type text),
#"Changed Type1" = Table.TransformColumnTypes(#"Inserted Text Before Delimiter",{{"Text Before Delimiter", type duration}})
in
#"Changed Type1"