Forum Discussion
Modelling Advice: Fact or Dimension Table
Thank you very much, Kurt, for your clear and swift answer.
Should I then have relationships between the "ticket" table and the time and sales tables? I read that there should never be relationships between fact tables
Gandalf12345,
Since 1, 2 and 3 are all ticket level facts, you might consider joining them all into one fact table.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
If I understand that correctly, I would then have sth like the following
Ticket ID machine id location id manager id creation date offer ID Offer Price Time Entry ID Time Entry Person Duration (min) 1 M1 L1 E1 01/01/24 O1 100 T1 A1 60 1 M1 L1 E1 01/01/24 O1 100 T2 A1 30 1 M1 L1 E1 01/01/24 O2 50 T1 A1 60 1 M1 L1 E1 01/01/24 O2 50 T2 A1 30 Would not this create a really, really huge table then? Or did I misunderstand?
Looks like we're on the same page. What do you mean by a "really, really huge table"?
