Forum Discussion
Multiple LOOKUPVALUE
Hi, im new in power bi and query and I would like to use the "Alternate" to evaluate a second condition of the function: LOOKUPVALUE( Table2[age], Table2[ID], Table1[ID], (LOOKUPVALUE (Table2[ag...
johnt75
Super User
Super UserThe code works fine with some sample data so I suspect the problem is in your data. You could try creating 2 calculated columns, one using each version of the LOOKUPVALUE, then investigate further into rows where you are getting blank or -1.