Dynamic Append Tables

ngct1112 , Assuming you are importing 5 excel. And they're power bi table now.

You can merge in power query as data prep, of the union in Dax. But that all is data prep.

This means If I want to choose two tables from the slicer and add/union. You will not be able to create a table dynamically and create a new table.

Measure can only use slicer value

so we can define a dynamic union table DAX measure and use that

or we can add table name as one of the columns in the source and use that slicer to give the feel that user is able to select the table

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.