Forum Discussion
Aussie_Dragon
3 years agoRegular Visitor
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...
- 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?")
Aussie_Dragon
3 years agoRegular Visitor
Thank you.
Is there any particular book that you can recommend regarding data model design in general?
lbendlin
Super User
3 years agoYou can start here Understand star schema and the importance for Power BI - Power BI | Microsoft Learn