Single wide table and dimensional schema

Hi SamyAbdul​ ,

Option 1 is right. On your specific question about observation periods and releases:

1. Keep each Gold fact at its own grain and period. If one dataset is monthly and another is annual, make both periodic snapshot facts and link each to dim_date at its own level, for example the first day of the period. Do not force them into one snapshot.
2. Treat source release as data, not as a filter. Store the release id on every fact row, plus an is_latest flag or a view that picks the latest release per hotel and period. Then reports default to current figures, and you can still reproduce older numbers.
3. Combine across facts in the semantic model, not in a wide table. Both facts filter through dim_hotel and dim_date, and measures from each sit side by side in one visual. If one fact is coarser than dim_date, Power BI handles that with the higher grain fact pattern.

Docs:

https://learn.microsoft.com/en-us/fabric/data-warehouse/dimensional-modeling-fact-tables

https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many

If this helps, please mark it as the solution.