Forum Discussion
Nearest value from another table with lookup criteria
But where is the query step that defines #RUNDC?
You are using it as previous step. PQ evaluates every step.
Try removing the #rundc.
It should work.
I am seeing any problem.
If my assistance helped you in any way, hit 👍
accept it as a solution.
It seems like you're encountering an error because the table reference #"RNDC IN Pricing ALL"is not defined in the provided code. To fix this issue, you need to make sure that the reference toTable1` (Pricing information) is correct.
DistinctPricing=Table.Distinct(Table.SelectColumns(#"RNDC IN Pricing ALL",{"Pricing Group","Deal Price"})),
adjust this line
Table 1 is actually called RNDC IN Pricing All so I believe the reference is correct. Let me know if anything else in the code is incorrect.
But where is the query step that defines #RUNDC?
You are using it as previous step. PQ evaluates every step.
Try removing the #rundc.
It should work.
I am seeing any problem.
If my assistance helped you in any way, hit 👍
accept it as a solution.