MetaQueriesPBIX

(PQTable as table) =>



let

    #"Added Index" = Table.AddIndexColumn(PQTable, "Index", 0, 1),

    #"Duplicated Column" = Table.DuplicateColumn(#"Added Index", "Column1", "Column1 - Copy"),

    #"Split Column by Delimiter" = Table.SplitColumn(#"Duplicated Column", "Column1 - Copy", Splitter.SplitTextByEachDelimiter({"="}, QuoteStyle.Csv, false), {"Part1", "Code"}),

    #"Trimmed Text" = Table.TransformColumns(#"Split Column by Delimiter",{{"Part1", Text.Trim}}),

    QueryName = Table.AddColumn(#"Trimmed Text", "QueryName", each if Text.Start([Column1], 6) = "shared" then if Text.Start([Column1],8)="shared #" then Text.Range([Column1],9, Text.Length([Part1])-8) else Text.Range([Column1], 7, Text.Length([Part1])-7) else null),

    StepName = Table.AddColumn(QueryName, "Stepname", each if [Part1]="in" or [Part1]="let" or  QueryName{[Index]-1}[Part1]="in" or [QueryName] <> null or Text.Start([Part1],2) = "//" then "" else Text.Trim([Part1])),

    #"Filled Down" = Table.FillDown(StepName,{"QueryName"})

in

    #"Filled Down"