Is it possible to join two matrix/table?

[Anonymous]

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 

[v-yalanwu-msft]

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.

[amitchandak]

@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]

They're created using same table. This is the matrices

[amitchandak]

@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

[Anonymous]

Is it possible to create them as variable table and join them?