Forum Discussion
Solved
Issue Managing Two Fact Tables
Hi, I have two fact tables; one for insurance product sales, and the other for claims. I also have two separate DIM tables, which are Calendar and Dealer. I need to identify which product sal...
One option would be to add a calculated column to the sales table, e.g.
Claim made = Sales[Sale ID] IN VALUES ( Claims[Sale ID] )
One option would be to add a calculated column to the sales table, e.g.
Claim made =
Sales[Sale ID] IN VALUES ( Claims[Sale ID] )