Forum Discussion

jppuam's avatar
jppuam
Helper V
4 years ago
Solved

LEFT OUTER JOIN not working

Hello, i've a table A with the follow: code_ID    department     costs 1               chemistry        100 2               math                200 3               sociology         300 4      ...
Need Help
  • Jos_Woolley's avatar
    Jos_Woolley
    4 years ago

    If the matching is to be based on all 3 columns:

    NewTable =
EXCEPT ( Table1, Table2 )

    Regards

jppuam's avatar
jppuam
Helper V
4 years ago

Maybe its because of the size ? I'm filterinig 1,8M lines ? 

The columns dont have any erros, can i do it by DAX ?

 

thanks,

JP

Jos_Woolley's avatar
Jos_Woolley
Solution Sage
4 years ago

Sorry, I'm afraid I don't know the answer as to why you're getting that error.

Regards