Forum Discussion

Vdferreira's avatar
Vdferreira
Frequent Visitor
5 years ago

Power BI DAX Table join with condition

Hello,

I need to connect two tables with a condition. Say we have two columns, Width and height, and i need to join the two tables with the same width value and bigger than or equal height.  How can i do this?

Thank you in advance.

 

Best regards,

Vasco.

4 Replies

    • Vdferreira's avatar
      Vdferreira
      Frequent Visitor

      This is what we currently have, the last column is a summarize of the values. Currently the connection between the tables in DAX is through a field called Largura, however we needed also to add a condition to a field called Altura with the condition being bigger than or equal.

  • Vdferreira's avatar
    Vdferreira
    Frequent Visitor

    Please i really need this, if anyone knows it would be very helpful 😁