Forum Discussion

Manas1415's avatar
Manas1415
Frequent Visitor
8 years ago
Solved

Using LOOKUPVALUE in IFERROR producing an error

Hi all, I am new to Power BI and I'm stuck in a particular scenario where I want to derive a Column Value from a MappingTable using Column_1 or Column_2 as Column references and display the correspo...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    This is the calculted column formula i used in Table2

     

    =IF(ISBLANK(LOOKUPVALUE(mappingtable[Result],mappingtable[Column_1],[Lookup_value])),LOOKUPVALUE(mappingtable[Result],mappingtable[Column_2],[Lookup_value]),LOOKUPVALUE(mappingtable[Result],mappingtable[Column_1],[Lookup_value]))

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

I cannot identify any mistake in your formula.  It looks like for there are duplicate values in Column_1 and/or Column_2 for the same task_name.  Please confirm if that is the case.

Manas1415's avatar
Manas1415
Frequent Visitor
8 years ago

Hi Ashish_Mathur,

 

Thanks for reaching out.

 

The values in both the Column_1 and Column_2 are unique.

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Have you checked my most recent post.