Forum Discussion
LookUpValue not working as expected
I have these two tables: Holidays: and Goals and the following Calculated Column in Holidays HolidayValue = LOOKUPVALUE(Goals[HolidayValue],Goals[Employee.id],Holidays[Employee.id...
Are the Employee.id and Year columns the same data type in both tables? You might have issues if, say, Goals[Year] is a text column but Holidays[Year] is an integer column.
Year and Employee.ID are "WHole Number" Data types.