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...
amitchandak I wish it was that easy. 😀
You see there is no direct relationship established in between Net Forecast and Stock On Hand table. There is intermediarry table here, which is required too.
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.