Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Join Multiple Fact tables with common fields

Good Day,   I trust this message finds you well. I need assistance.   I currently have 3 Fact tables: Sales MTD which has 2 Months of data (Current Month and Previous Month) Sales YTD which has 1...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , if the data in fact is not  overlapping, then you can append these tables

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

for rest you can have one or more common dimension like channel, operation manager etc and and join with these facts with 1-M join.

 

refer how to build such dimensions

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

 

 

else joined month end date /date in all tables with date dim