Forum Discussion
Solved
category slicer
ahadkarimi Which is the best way to combine categories from different tables. The scenario is the following: I have 3 tables from 3 different years. All have the same column headers. I have a ...
SCallanan - These 3 tables should be appended in Power Query rather than trying to handle this in DAX, it will be much easier, optimal and better for your model.
Please see the guidance on this here: https://learn.microsoft.com/en-us/power-query/append-queries
If this works, please accept it as a solution, it helps with visibility for others.
mark_endicott
Super User
Super UserSCallanan - These 3 tables should be appended in Power Query rather than trying to handle this in DAX, it will be much easier, optimal and better for your model.
Please see the guidance on this here: https://learn.microsoft.com/en-us/power-query/append-queries
If this works, please accept it as a solution, it helps with visibility for others.