Forum Discussion

hnguyen76's avatar
hnguyen76
Resolver II
6 years ago
Solved

DAX LeftouterJoin No Relationship

Hi All. I'm attempting to create an attribute table from two fact tables in DAX. I'm fully aware that this is far easier and better to do in PowerQuery except that I'm using a database that has slow...
Need Help
  • hnguyen76's avatar
    hnguyen76
    6 years ago

    v-juanli-msft ,
    Thanks for the reply. Unfortunately I was looking for a route that did not consider using any relationships (active or inactive) while actively avoiding M-2-M. Considering performance vs data model size I opted with my original solution to use PowerQuery 

amitchandak's avatar
amitchandak
Super User
6 years ago

You can use a cross join in Dax but it will make things slow. You can use it inside the filter to have your condition.

Also, use selectcolumns to rename and select columns as this will not Allow same name column.

 

Use summarize of top of it.

  • hnguyen76's avatar
    hnguyen76
    Resolver II
    6 years ago

    amitchandak ,

    CROSSJOIN is definitely out of the question. I tried it with my dataset yesterday and it returned me 2 billion rows and took about 20 minutes to evaluate. 

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      I think the option you planning to use of power query is better. What you actally want to achieve using merge