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.

     

Manohar30's avatar
Manohar30
Microsoft Employee
5 years ago

Hi Team,

I am new to Power BI and I'm stuck in a particular scenario where I want to convert this Vlookup in excel formula to Power Bi.

Excel vlookup formula: =IFERROR(VLOOKUP([@Team],NTEbyTeam3[[Org]:[FY20NTE]],2,FALSE)/IF([@[Approved Ind]]="N",0,IF([@[Budget]]=-1,0,SUMIFS([TotalPo],[Team],[@Team],[Budget],0))),0)

 

In power Bi i need to convert this expression. Any help is appriciated. 

 

Thank you,

Manohar.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Share some data, explain the question and show the expected result.