Forum Discussion
randeep
Helper I
6 years agoConditional join on multiple columns
I have following model, which are imported into my project. I would like to either have COGS field from Stock On Hand into Net Forecast or vice versa, by connecting product and date fiel...
amitchandak
Super User
6 years agorandeep , you do not have a stock status table?
randeep
Helper I
6 years agoYes, but the relationship between Stock Status and Net Forecast on Product field. And Stock Status and Stock On Hand on Product field.
The Date field is connected to Calendar table.
When I use you proposed formula, it just sums up entire table.