Sorry for the poor title, I’m struggling to put into words what I need and I am a beginner with Power Query.

Basically, I have a selection of Price Sub Groups where the NPTR is incorrect and I need them to specifically reflect the NPTR that the On Premise Price Sub Group has. In the example, I thought I would create a custom column for this, but I can’t figure out how to reference specifically the NPTR of a single Price Sub Group instead of an entire column of values.

There are many products so it’s not just the one specific static cell either.

Thank you for your help!

Example

Here’s what I tried, but it is not specific enough. I don’t need NPTR in general, I need the On Premise NPTR.

= Table.AddColumn(#"Replaced Value2", "Custom", each if List.Contains ({"TIER I", "TIER II", "LEGACY I", "LEGACY II", "AIRPORT", "CONCESSIONS"},[Price Sub Group]) then **[NPTR]** else [FPTR])