2 fact tables simultaneously?

[Anonymous]

I have a standard matrix visual in Power BI, which is displaying around 8 measures.

The matrix uses a Fact table, 2 dimension tables and a DimDate.

So far, it works as expected, but now new data has to be added to the matrix, but this data is in is a New Fact table.

• Can this be done without connecting the 2 fact tables between them?

The new fact table can be connected to all the dimensions the other fact table can...

[Anonymous]

Hi @Anonymous ,

You may consider creating a relationship between the two tables. When you import multiple tables, chances are you'll do some analysis using data from all those tables. Relationships between those tables are necessary to accurately calculate results and display the correct information in your reports.

Please refer to the following document for further information.

https://docs.microsoft.com/power-bi/transform-model/desktop-create-and-manage-relationships

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I can't because I am consuming from an SSAS cube, I cannot use power query.

[amitchandak]

@Anonymous , If this has the same structure them merge it with the first table in the power query

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

Otherwise you have to join ti with common dimensions