Dynamic Matrix table

[Sansudhi8]

Dear All,

Kindly look into the attached Power BI project. I have 2 data set which extracted from different system. So I have to create 1 table or Matrix table which change with Slicer. Could you please look into this and give me a solution for this.

Please let me know if you require any further details. Simply I just need 1 table from both data set.

Thank you very much for your time.

Project

[Greg_Deckler · Accepted solution]

I downloaded your file but I do not understand what your expect as your output? The tables do not seem to have all of the same columns in them. But, you should be able to use an Append Query to essentially UNION the tables together. I would recommend making sure as many column names matched as possible. You could also do it in DAX using the UNION function but I think that you will need to make sure that your columns are in the same order in both tables. I am uploading a version of your file that does a DAX UNION.