Forum Discussion
Dynamic Append Tables
amitchandak Sorry for my misleading. In this case, I am not putting the Data in PowerBI but excel only.
Is it possible the users can choose which tables to be appended by doing filter in the excel sheet? Thanks.
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.
amitchandak I have attached the simpified Excel file. Sample Excel File
What I am trying to do is a dynamic way for the user to select which tables to be included(appended) in the Result tab.
And NO powerbi will be involved.
Great thanks!