Forum Discussion

sbm_tekade's avatar
sbm_tekade
Frequent Visitor
3 years ago

What is fast M language or DAX query for full outer join?

I have two tables from two different sourcesand wanted to perform full outer join on them to check mis-matches in both table and on top of that few extra columns working as indicators or flags for mis-match.

Having existing model for this but it is taking time to refresh the report manually on desktop as well as on service.

How can I overcome this situation? 

 

Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi sbm_tekade - My first thought is try an reduce the scope of the comparison to smaller sub-set.  The smaller set will be less memory intensive, so PBI Desktop or the Service can use memory more effectively.  But without a more detail it is hard to provide advice.

    Can I suggest add more detail to help.  Eg what are the data sources, how big are the tables, what columns are you trying to compare.  The answer will depend a lot on the answers to the above.

    Many thanks

    Daryl