Forum Discussion
Export multiple table visuals to one excel
I would to export all the 4 tables shown in the screenshot below to one excel file. How can I approach this. I was thinking to build this in powerbi builder and give the end user a button to send...
Hello Reda899 ,
You can simply create a new table using DAX
New_Table = UNION(Table1, Table2, Table3, Table4)
(This only works when you have the same columns on all 4 tables)
This will give you a single view of data from which your users can export data directly.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
I should have mentioned that it's not all same columns with same calculations. So thats the issue I am facing.