Forum Discussion
Left join in SQL transfer to Dax Messure
Hello together, my SQL is: select Tab2.Comment from Tab1 leftjoin Tab2 ON (Tab1.ID = Tab2.ID ) As we use the direct query so a merge in Table is not possible. We need this join as a mes...
hi Anonymous
In power bi, for your case, you just need to create a relationship between two tables by ID column, then use slicer to filter visual.
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Regards,
Lin
hi Anonymous
In power bi, for your case, you just need to create a relationship between two tables by ID column, then use slicer to filter visual.
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Regards,
Lin