1 to 1 Relationship Modeling or Merging

I have two fact tables A and B. A is about projects status and B is about project financials. They are 1 to 1 relationship. In this case, when I model the data, is it best to create a 1 to 1 relationship diagram between them or merge them as a single 1 fact table in the query editor?

Probably best to keep them separate. Only way to give you a better answer is if you could share a pbix file or something that shows all of the columns in each of the table. More than likely going to keep them they way they are.

Thanks

Enterprise%20DNA%20Expert%20-%20Small

The most likely answer to this will be to keep them separate, but have a linking table (lookup table), which just has a list of the ‘projects’

For more information on this idea. See below