Forum Discussion

Aussie_Dragon's avatar
Aussie_Dragon
Regular Visitor
3 years ago
Solved

Represent Different One to Many [Received Dates] on Same Timeline

Hello Everyone,   Apologies for the simple question, I am new to Dax.   Most of the learnings seem to cover Order examples, however, my question relates to scenarios where you have an enquiry whi...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Here's a preliminary view of how the data model could be structured

    Note that the relationship between Enquiry and Issues is inactive (and practically useless) since it would introduce ambiguity. It will be easier to use TREATAS in this scenario.

    The main question is - what is your focus on?  Is it a calendar view  ("what happened this month?") or a entity view ("What happened to Enquiries over time?")

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

There is another option - you can change the search direction to make the relationship bidirectional between one of the fact tables (Enquiry) and the dimension table (Dates).  However that is frowned upon as it will likely create trouble down the road.

Aussie_Dragon's avatar
Aussie_Dragon
Regular Visitor
3 years ago

Thank you.

 

Is there any particular book that you can recommend regarding data model design in general?