Forum Discussion
Solved
LOOKUPVALUE error
PrevFLComments = VAR Userx = 'Daily Certification Full'[Emp Full Name] VAR PrevDate = DATEADD('Daily Certification Full'[DateEntered],-1,MONTH) RETURN COALESCE(LOOKUPVALUE('Daily Certification ...
It appears that 'Daily Certification Full'[Field Leader Comment] has multiple values resulting from the lookup. You could use FILTER to create a virtual table with the relevant rows, and then use CONCATENATEX to concatenate the values in the virtual table.
It appears that 'Daily Certification Full'[Field Leader Comment] has multiple values resulting from the lookup. You could use FILTER to create a virtual table with the relevant rows, and then use CONCATENATEX to concatenate the values in the virtual table.
Thank you and yes, I found that there is some "test" data being delivered and it has duplicate entries. I filtered that and it is good. Thanks for the reply