What is the best way to relate two fact tables?

[Anonymous]

What is the best way to relate two fact tables?

[sanalytics · Accepted solution]

@Anonymous 
The idle way to connect 2 fact table by a Dimension table..
create a Unique Dimesion table from your fact table then make one to many relationship..
Have a look into below sceenshot..

Attached link is power bi file..

https://we.tl/t-9wjZEhYklG
for better result please post your power bi model and exact requirement.

Regards,

sanalytics

If it is your solution then please Accept it as solution and please like.

[negi007 · Accepted solution]

@Anonymous  Ideally, you should have one main table (can be called dimension table) which will have a unique field to connect to other tables (could be fact tables). Then you can create one-to-one relationship between your dimension table and fact table. It will be greate if you can share your dataset view so can assist you accordingly. However, you should follow one dimension table to multiple fact table relationship. this will also help in createing star schema in your dataset.

[sanalytics · Accepted solution]

@Anonymous 
The idle way to connect 2 fact table by a Dimension table..
create a Unique Dimesion table from your fact table then make one to many relationship..
Have a look into below sceenshot..

Attached link is power bi file..

https://we.tl/t-9wjZEhYklG
for better result please post your power bi model and exact requirement.

Regards,

sanalytics

If it is your solution then please Accept it as solution and please like.