Generating a TimeGenerated column from the Source.Name

Hi Anonymous ,

Add this as a new custom column:

let numbers = Text.Select([Source.Name], {"0".."9"}) in
#date(
    Number.From(Text.Start(numbers, 4)),
    Number.From(Text.Middle(numbers, 4, 2)),
    Number.From(Text.End(numbers, 2))
)

For this output:

Full example query:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wckkty0xOLTYyMDI2MDWw0Msqzs9TitVBljAyNDIyhUrEAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Source.Name = _t]),
    addTimeGenerated =
        Table.AddColumn(
            Source,
            "Time Generated",
            each let numbers = Text.Select([Source.Name], {"0".."9"}) in
            #date(
                Number.From(Text.Start(numbers, 4)),
                Number.From(Text.Middle(numbers, 4, 2)),
                Number.From(Text.End(numbers, 2))
            )
        )
in
    addTimeGenerated

Pete