Forum Discussion
WBscooby
Helper III
Helper IIIData Model - Multiple tables with Start and End Dates
Hi I am hoping for some advice on how best to model my data. I have the following key tables (simplified examples due to the privacy nature of the data): Date Calendar Client Table: Clien...
zenisekd
Super User
Super UserHi,
Client Episode is a Fact table
Client table and Client address and Date table are Dimension tables.
If you have multiple client episode tables, then I would suggest you append them in Power Query. To have just one large fact table (add a column, which would specify, what type of episode table it was, so you can query by it as well).
You mention event table, but you do not specify it..?
Finally, if you were to calculate something by the start and end date, you can refer to this video:
https://www.youtube.com/watch?v=8ozINFvuiUg&ab_channel=EnterpriseDNA.
Kudos and Mark as solution appreciated 🙂