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.

     

Manas1415's avatar
Manas1415
Frequent Visitor
8 years ago

Hi v-huizhn-msft,

 

First of all, thanks for reaching out.

 

My MappingTable looks like this:

 

So basically, I'm performing a lookup to fetch the value from the ResultColumn using Column_1 as reference, where if there is a NULL value, I want to use the Column_2 as reference and fetch the corresponding value from the ResultColumn.

 

Hope this clears what I'm trying to ask. :)

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.

 

  • Manas1415's avatar
    Manas1415
    Frequent Visitor
    8 years ago

    Hi Ashish_Mathur,

     

    I understand the logic that you used while building the expression but sadly, your expression too gives the same error.

    I'm attaching a screenshot of the same:

     

     

    Where,

    Task Categories -> MappingTable

    Data Edit -> MainTable

    Category -> ResultColumn

    TaskName -> LookUp Value Column (Search Value)

     

    I don't understand what's going wrong here. 

    Thanks for looking into this.

    • 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.