what the differens between "generate all" and "Natural left outer join"?

[Anonymous]

What is the difference between the function "generate all" and the function "Natural left outer join"?
Which one do you recommend?

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

GENERATEALL is to generate a new table based on the base table and the expression.

NATURALLEFTOUTERJOIN is to merge the common columns of two tables.
Depending on your needs.

Best Regards,

Link

[Anonymous]

@amitchandak 
I'm sorry, I was wrong.
It was "generate all" instead of the function "general all".
I also corrected the question.

[amitchandak]

@Anonymous , I am not sure on "general all", can you provide more details on that.

this a good blog on power bi DAX joins

refer if this can help

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/