This is an advanced technique that can be used for creating a specimen list. It is similar to the UNION command in SQL.
The tables must have the same fields to be combined successfully in Power BI.
The example below illustrates how to create a specimen list. To prepare the data for this merge follow the steps below.
To create a new table that merges these tables together follow the steps below:-
Once this table has been created, it can be used to join to the lab test results tables to create a single table showing all lab results by the specimen.