Forum Discussion
M&A Dynamic Visual Matrix
Hi there, I'm pretty new to this community and to Power BI as well. Hope to find a solution or at least an answer to my question. I am performing a controlling project, in which we are analyzing f...
One approach would be to add a column to your company dimension table that groups companies. In this example, companies A and B were merged into company A.
Data model:
Here's the result using each field in DimCompany:
Hi, thanks for your reply.
The issue is not solved in this way, as M&A is not a static data, in this case two or more companies can be merged during 2023, but have performed stand alone for years. In this case the merging relations it is not only based on companies but also based on the year of merging.
Can you share a sanitized pbix via one of the file services, along with an example of the expected result?