Forum Discussion

_Regina's avatar
_Regina
Helper I
2 years ago
Solved

Multiple Dates with Inactive Relation

Hi everyone, In my power bi data model , I have a table 'Onboarding Request' which has multiple date columns. This table has active relation with date table based on Apllication_Start_Date_Dim_Sysid...
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi _Regina 

    It sounds like in this case, the best stragegy for you is to have your calendar table and your multiple dates fact table as disconnected tables.  When the multiple dates fact table requires analysis of duration like period from and period to, you won't be able to perform your intended analysis if the relationship is created between the calendar table and your fact table, and they need to be disconnected tables for you to perform your intended analysis.   Or else, if the analysis you require doesn't involve duration calculation, you can use Userelationship function to activate your inactive relationship in a specific measure. 

    Best regards,

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi _Regina ,

 

Hi @VenuDakoju ,

 

Whether the advice given by DataNinja777   has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.