Forum Discussion
Relationship Between 2 Tables - Slicer Management - Please Help!!!
I have two sets of data that have a relationship, joined by Customer ID. Because of the nature of how the data is sent to me, I would like to only show the data where records have a match. That is ...
Hi Anonymous,
Please check the formula as below to work on it.
Column = var rsult =LOOKUPVALUE(TableB[Customer ID],TableB[Customer ID],'Table A'[Customer ID]) return IF(ISBLANK(rsult),FALSE(),TRUE())
Also please find the file attached.
Regards,
Frank
v-frfei-msft
Community Support
Community SupportHi Anonymous,
Please check the formula as below to work on it.
Column = var rsult =LOOKUPVALUE(TableB[Customer ID],TableB[Customer ID],'Table A'[Customer ID]) return IF(ISBLANK(rsult),FALSE(),TRUE())
Also please find the file attached.
Regards,
Frank
v-frfei-msftCommunity Support
Community SupportHi Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank