Hello,
Thank you for taking the time to read my question.
I have two unrelated tables.
Table A: Supervisor, Group Label, Include(Yes/No), Extract Date, Date/Label (just concatenated Extract Date and Supervisor)
Table B: Month/Year, Supervisor
I would like to filter Table A as "Yes" and then carry out an IF statement e.g.
FILTER(Table A, Table A[Include(Yes/No)]="Yes"), IF(ISBLANK(LOOKUPVALUE('Table B[Group Label],Table B[Date/Label], concatenate(Table A[Month/Year],Table A[Supervisor]))),"-",LOOKUPVALUE('Table B[Group Label],Table B[Date/Label], concatenate(Table A[Month/Year],Table A[Supervisor])))
Obviously the above formula doesnt work.
If I type in:
IF(ISBLANK(LOOKUPVALUE('Table B[Group Label],Table B[Date/Label], concatenate(Table A[Month/Year],Table A[Supervisor]))),"-",LOOKUPVALUE('Table B[Group Label],Table B[Date/Label], concatenate(Table A[Month/Year],Table A[Supervisor])))
Then this gives me error saying "A table of multiple values was supplied where a single value was expected"
Any help is appreciated- thank you 🙂
