multi fact tables

 Power BI Modelling — Using a Multi-Fact Model | by Peter Hui | Towards Data Science

So maybe you are thinking of having a multi-fact table model, how do you go about doing this?

You will need to do the following. I have provided an example from the few points above.

1. Identify the two fact tables — Budget vs Expenses
2. Agree on the granularity — Monthly, with the ability to drill
3. Identify the common dimensions — Region and Dates
4. Link the dimensions — Only 1: Many joins