Forum Discussion
Multiple relationships between multiple tables
Hi, I have an issue with relationships set in my dataset. I have 4 related tables Calendar, Sales Data, Brands, Forecast, with the below relationships: 1. Calendar => Forecast (Date=Date)...
Hey Anonymous can you send a snippet of the structure of your tables ?
A print screen that shows the columns in each table its more than fine
Anonymous Below you can see the structure of my actual model. I'd like to link Forecast Table to Channel Table. As a primary key I have channel name in both tables. Whenever the channel filter will be applied to my visual, I'd like to see the Forecast shown per channel.
I can create channel colum in Sales table also (if it will be required).
Any suggestion can help.
Thanks.