Forum Discussion

wolfgangkb-work's avatar
wolfgangkb-work
Helper I
4 years ago

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...
Need Help
ddpl's avatar
ddpl
Solution Sage
4 years ago

Hi,

Try this using merge from power query:

Holliday Table:

 

Gola Table:

 

 

 

Merge table: