Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Vdferreira
Frequent Visitor

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 4
Vdferreira
Frequent Visitor

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

Sorry, I don't know your scenario. Please refer to this blog how to describe your problem.

If you are in table visual, you can use a filter or slicer in the Altura field.

ryan_mayu
Super User
Super User

@Vdferreira 

could you pls provide the sample data and expected output?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Vdferreira_0-1628071892622.jpeg

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.