Custom Column - M formula error

[AlBud]

Hi all,

I can't quite work out why I'm getting the "Token Equal expected" error.

(let PO# = [POnumber] in Table.SelectRows (purchaseDocuments, each [POnumber] = PO#)){0} [amount]

The "Merged" table is where I'm creating the the custom column, and I'm trying to get "PO#" to look up the "POnumber" in the "purchaseDocuments" table and return the "amount" value from the "purchaseDocuments" table for the corresponding "PO#" in the "Merged" table.

[Vijay_A_Verma]

Use this

let 
#"PO#" = [POnumber]
in 
Table.SelectRows (purchaseDocuments, each [POnumber] = #"PO#"){0} [amount]

👍 It's been a pleasure to help you | Help Hours: 11 AM to 9 PM (UTC+05:30)

How to get your questions answered quickly -- How to provide sample data

[AlBud]

Hi Vijay,

The formula works, but I get an error in the resulting created column. What have I missed?

The "Merged" table is where I'm creating the the custom column, and I'm trying to get "PO#" to look up the "POnumber" in the "purchaseDocuments" table and return the "amount" value from the "purchaseDocuments" table for the corresponding "PO#" in the "Merged" table.

Both tables have been refreshed.

[Vijay_A_Verma · Accepted solution]

Put following formula in custom column box

= try purchaseDocuments{[POnumber=[#"PO#"]]}[amount] otherwise null

👍 It's been a pleasure to help you | Help Hours: 11 AM to 9 PM (UTC+05:30)

How to get your questions answered quickly -- How to provide sample data