Forum Discussion
Simple LOOKUPVALUE
Hi leadacid ,
If the value you are trying to assign with lookup is the same for the key values for which you are doing lookup, lookup should work. If the values change; You will get an error like "expected single value".
Could you check if all shifts are the same for particular number_id of persons? What is the datatype of shift data? Sometimes, even if it says date, the data may be in datetime format. In other words, these data may differ from each other even if they appear the same.My second question is, is there a relationship between these two tables? Could you try connecting the ids in these two tables from the "Managing relationship" section?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi leadacid ,
If the value you are trying to assign with lookup is the same for the key values for which you are doing lookup, lookup should work. If the values change; You will get an error like "expected single value".
Could you check if all shifts are the same for particular number_id of persons? What is the datatype of shift data? Sometimes, even if it says date, the data may be in datetime format. In other words, these data may differ from each other even if they appear the same.
My second question is, is there a relationship between these two tables? Could you try connecting the ids in these two tables from the "Managing relationship" section?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! This worked:
Employee's Shift = LOOKUPVALUE('Employee Profile'[Shift],'Employee Profile'[Person Number],'Average Earning'[ID])
