Forum Discussion
Solved
Merging Tables Efficiency Question
PowerBI SuperUsers, I have a PowerBI filw with two tables pulled from SQL 1) Sales Table 2) Product Table I"m trying to figure out the most efficient way to merch 2 columns from the prod...
Hi boldwake,
According to your description, I would suggest you to keeping doing it in DAX for performance purpose. By this way, you can keep making use of the physical relationships to get best performance and the best use of the VertiPaq engine.:smileyhappy:
In addtion, another possible solution is to use the LOOKUPVALUE function. Using LOOKUPVALUE you can denormalize the Brand & Category directly in the Sales table, by defining a new calculated column in Sales table. This solution can make the code simple to author.
Regards
