Forum Discussion
Solved
How do I reference a specific cell value from a 2nd table inside of a formula on a different table?
I have a table that has the following formula: = Table.AddColumn(#"Changed Type2", "Qty Forecast", each if [Quantity] <= 0 then [Quantity] else ([Quantity] / (List.Sum(#"Changed Type2"[Amount]) ...
Hi jk8979356
Please try this, you should get that column from your forecast table to your current table and then you can use it in your formula.
Please refer this.
Thanks,
Ankit
I have read that discussion, but don't understand the exact M code I need in my situation. I'm fine if I need to first bring in the value from the forecast table into the sales table, but what exact M code do I use to do this? Since there is only a single value in the forecast table and I am not using a match of any kind, but rather using 1 single value for all rows, what code do I use to add the forecast value into my sales table as a new column?
