Forum Discussion
Is it possible to join two matrix/table?
I have two tables/matrices with common categorical row. Is it possible to do inner join on these two tables/matrices on that common dimension?
I need to merge these two matrices
5 Replies
Anonymous , That will create a many to many join create a common dimension and join with that
category= distinct(union(distinct(Table1[category]),distinct(Table2[category])))
https://www.seerinteractive.com/blog/join-many-many-power-bi/
Anonymous , Not sure, But the screenshot was not there when I checked last If Adj TAT and final TAT are columns you can add them to the matrix. , But if they are values of two different columns then some modelling is required
Can share raw/source data data
Hi, Anonymous ;
In a matrix directly FIN_TAT put ADJ_TAT after it is ok, can you simply file to remove sensitive information? Not familiar with the raw data model?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
