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,

 

You are not sharing the complete information.  You only shared one table initially whereas you have more than 1 table.  Share the link from where i can download the file and state the requirements clearly.

Manas1415's avatar
Manas1415
Frequent Visitor
8 years ago

Hi,

 

I have TWO tables:

1. MainTable

2. MappingTable

 

I want to fetch a value from the MappingTable and display it on the MainTable using a conditional lookup.

I've also edited the main post along with sample table structures.

 

Please see if it helps.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    My post about an hour ago should solve the problem.  If it does not, then share the link from where i can download your file.