cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!