Forum Discussion
2 fact tables simultaneously?
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...
3 Replies
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
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.
