Power Query - Custom Column Logic for Multiple Queries

[johnny51981]

I have 2 data sources that come from the same application, but one is for Sales and one is for Invoicing. The columns are all named and formatted the same.

There is a Custom Column in queries that use those 2 data sources where the logic is to be exactly the same...but sometimes out of sight out of mind and I end up not tying out.

Is there a way to create the Custom Column in a single location for editing purposes, but is used in more than one query?

Let's just say, for very very simple example's sake, that my columns are Job Number, Line Item Type, Status and logic is
if [Line Item Type] <> "Progressive" and [Status] = "Approved" then "Yes" else "No"

 

[ExcelToDAX]

If you add the following code below, you need to invoke the custom function, and then reference the last step instead of the table name.

(tblName as table) =>
let
    Source = Table.AddColumn(tblName, "Custom", each if [Line Item Type] <> "Progressive" and [Status] = "Approved" then "Yes" else "No")
in
    Source

Your next step would look something like (assuming you named your custom function and the previous step is called #"Changed Type"):

= Table.AddColumn(#"Changed Type", "Custom Column", each fnCustomColumn(#"Changed Type"))

 

[johnny51981]

If you add the following code below, you need to invoke the custom function, and then reference the last step instead of the table name.

(tblName as table) =>
let
    Source = Table.AddColumn(tblName, "Custom", each if [Line Item Type] <> "Progressive" and [Status] = "Approved" then "Yes" else "No")
in
    Source

Your next step would look something like (assuming you named your custom function and the previous step is called #"Changed Type"):

= Table.AddColumn(#"Changed Type", "Custom Column", each fnCustomColumn(#"Changed Type"))

This looks to be the solution I was seeking. Appreciate it!