Forum Discussion

KayceVC's avatar
KayceVC
Icon for Helper II rankHelper II
7 years ago

Inactive Relationship Between Dates

I have a report with multiple tables (including a dates table) all of which are imported from SQL. I already have 2 relationships from Dates to a survey table, but when I attempt to create a 2nd inac...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, KayceVC 

I think this case should not only happen between dates. It should be a performance problem.

For the performance problem, the best way is optimize your data model, and for your case, the model must be big and complex.

So if you should optimize your data model or formula. and here is a blog for you refer to:

https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/

 

Best Regards,

Lin

 

 

  • KayceVC's avatar
    KayceVC
    Icon for Helper II rankHelper II
    7 years ago

    I tried creating a seperate table just for the Resolved Date with the same result. As soon as a relationship between the dates table and Resolved Date is made, the relationship takes upwards of 15 mins to create/edit (though it will delete instantly) and reduces measure/calculated column performance to the same amount of time to create/edit/delete.