Table of multiple values

[sromondas]

Hello folks,

I have a formula for a new column as follows but i keep running into a "A table of multiple values was supplied...." error.

I have about 4 million rows in my data set.

powerbiResponseTime =

    IF (

        Mail[powerbiResponse] = 1,

        (LOOKUPVALUE (Mail[DateTimeSent],Mail[Attributes.InternetMessageId], Mail[Attributes.InReplyTo])),

        0

    )

What i want the formula to do is, for each row, look up the value from the Attributes.InReplyTo field in the Attributes.InternetMessageId field, and pull the corresponding date. I believe the lookup value syntax is correct but not sure why i get the error.

Thanks as always

[FreemanZ]

hi @sromondas 

you get this error, because there are multiple ocassions when

Mail[Attributes.InternetMessageId] = Mail[Attributes.InReplyTo])