Custom Function in Query

Hi. Sure. You can go to "Edit Queries" or "Transform Data". In that screen you can add columns or do transformations like this one.

Click on the ID column, go to "transform" tab and select Extract->After delimiter. Then write "-" and accept. Then  you have your result.

If you want to learn some M this is the function to do it:

= Table.TransformColumns(#"LastStep", {{"ColumnName", each Text.AfterDelimiter(Text.From(_), "-"), type text}})

Replace LastStep and ColumnName with your data.

Regards, 

Hi Anonymous ,

Even if you use "invoke Custom Functions", still create a function for each table, Unless you merge all your tables into one table.

You can refer to the code:

let
    Source = () => let
        Source = Excel.Workbook(File.Contents("C:\Users\xxx\Desktop\x4.xlsx"), null, true),
        Sheet6_Sheet = Source{[Item="Sheet6",Kind="Sheet"]}[Data],
        #"Changed Type" = Table.TransformColumnTypes(Sheet6_Sheet,{{"Column1", type text}}),
        #"Extracted Text After Delimiter" = Table.TransformColumns(#"Changed Type", {{"Column1", each Text.AfterDelimiter(_, "-"), type text}})
    in
       #"Extracted Text After Delimiter"
in
    Source

So, the most effective way is to refer to ibarrau 's answer.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.