Forum Discussion
Conditional join on multiple columns
randeep , As long as you have common dimensions like product and Date and Facts like Stock on Hand and net forecast join to those as shown in the relationship in power BI,
You can create a new measure
New measure = divide(sum('Net Forecast'[COGS]) ,sum('Stock On Hand'[COGS]))
and should able analyze that across Product and dates and any other common dimension
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.
