Lookupvalue from another table not related

[Anonymous]

Hi,

I'm trying to create a calculated column and this formula worked before but doesnt now. Maybe it was an update or a wrong formula from the beginning.

I want to pull in the location of the budget for a given [Tech]. These locations can change over different months and I want the fact table to track along with the Budget table. These two tables are fact tables and only have a many to many relationship connection with the Dates table. Can someone help with this code? 

I am getting an error "A Table of multiple values was supplied where a singe value was expected."

Thanks!

Budget Location = LOOKUPVALUE('Budget'[Location Code],

'Budget'[Tech ID],

'Clock'[Tech ID],

'Budget'[Date],

'Clock'[Start Date])

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

The <Search Value> for LOOKUPVALUE needs to be a single value, you're supplying an entire column.

LOOKUPVALUE – DAX Guide

In you're case you are using 2 <Search Values> in the 3rd and 5th arguments.

If you can supply some sample data and what your expected result would be, I can see if I can assist further.

Regards

Phil