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.

     

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Manas1415,

>> which I want to use as the reference column if the Column_1 is NULL to display the Output from the ResultColumn in both the cases.

What's the meaning of both cases? From your formula, ResultColumn only exist 'MappingTable' table. 

In addition, it's hard to reproduce your scenario without sample table, please share your sample table for further analysis.

Best Regards,
Angelia

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.