Forum Discussion
Conditional 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...
randeep , you do not have a stock status table?
Yes, 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.