Forum Discussion
daxesh
10 years agoFrequent Visitor
AS > Tabular Model > How to set multiple relationships between 2 tables?
Hello, I am new at preparing Tabular Model using SSAS and have got a query which I feel should be very easy for you experts to address. I plan to use this model in Power BI. My problem is – I am un...
ImkeF
10 years agoCommunity Champion
You can import the calender table twice. They normally don't cost (performance).
If you prepare your visualizations, make sure their calendar filters don't interact.
- vinaypugalia10 years agoResolver I
Yes, you can prepare a copy of the calendar table as Imke has guided but please note that as per my knowledge, you will not be able to mark it as a "Date Table" as 1 data model can have only 1 data table.
ImkeF please correct me if I am worng and if this is correct, please suggest a way to handle this.
Thanks!