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)...
Unfortunately this scenario is not possible for me as the dashboard is pretty big and a lot of data/calculated colums/measures will be impacted if the model will be changed. I'm thinking about a DAX calculation maybe?
Anyway, thank you very much for your input.
v-cazheng-msft
Community Support
Community SupportHi, Anonymous
If so, you can consider doing calculation with TREATAS function which can create virtual relationship. And then use the result to create the visual.
Best Regards
Caiyun Zheng