A table of multiple values error

[123rickfear]

Hi, this was working last week, now appear to be causing an error.

I have 2 tables, one is called inbox and one is sent items.

inbox has from, subject, cc, received time, powerapps id as standard

sent items has the same plus some formula.

Original Subject = if(left('Sent Items'[SUBJECT],4)="FW: ",'Sent Items'[SUBJECT],right('Sent Items'[SUBJECT],len('Sent Items'[SUBJECT])-4))

Received Day = lookupvalue(Inbox[RECEIVED TIME],Inbox[SUBJECT],'Sent Items'[Original Subject])

Original subject works fine. Received day now displays the message "a table of multiple values was supplied where a single value was expected".

Does anyone have any ideas why this is happening?

 

[macfuller]

Re: A tbale of multiple values error

From the DAX documentation:

If multiple rows match the search values and in all cases result_column values are identical then that value is returned. However, if result_column returns different values an error is returned.

Did your source data change to throw off the error? Two messages with the same received time?

 

[123rickfear]

Re: A tbale of multiple values error

yes in the sent items table.

Is this the issue then?

Is there a way around this?

 

[macfuller]

Re: A tbale of multiple values error

Hard to know if that's the issue without seeing the data. If you use Power Query for the data load try eliminating duplicates to see if that solves your issue and confirms the problem.

If it is the problem it's hard to say what might help. You could introduce some "jitter" into the received time when you import it... add a random number of seconds or minutes so that everything is likely to be unique.

 

[123rickfear]

Re: A tbale of multiple values error

Hi all, thanks for all your help.

I fixed this by creating a new column that was sender & date, which has removed the possibility of duplicates.