Hi
I am having a table A and Table B
Table A has a column called Features
Feature is a EnumList with base type Text
Table B also have a column called Specification
Specification is a EnumList with base type Text
What i am expecting is when i add a record in Table A with some feature like TV ,Camera
I need to select the row in Table B with the Features value added in Table A
Note:
Features and Speciation has the same values like Tv, Camera
I tried a expression with slice but it does not work,
INDEX(SELECT(Table A[Features],[USEREMAIL]=USEREMAIL()),COUNT(select(Table A[Features],[USEREMAIL]=USEREMAIL())))=[_THISROW].[Features],=
Please suggest me expression to filter the row
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |