Forum Discussion
Merge multiple tables using GENERATEALL
First, let me say that many of the tables I intend to use are calculated tables and thus I cannot use M/PowerQuery to do my merging. I am using the following the following DAX query to merge two ...
why you cannot create the calculated tables in Power Query? Is it technical constraint, or a legacy setup?
This problem would be much easier in PowerQuery, you technically can do it in DAX, but I honestly believe that you shouldn't
The reason is because of performance issues. I am working with very unresponsive SQL tables and when attempting to merge tables, group by and create calculated columns I would often have to wait an hour for the program to finish each operation while using DAX to perform the same operation it took 5 minutes. Due to the complexity of the relationship I need to build between the tables, Power Query bogged down my report too much.