Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Mcode:Error result If Look Up Value doesnt exist at Source table (should show as blank not "Error")

I have a table that looks up a value from another table namely LookUp table and Review table. I have below MCode in my custom column in Review table.   = (let currentLookUp = [UniqueValue] in Table...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

     

    It takes time to scan so many rows while using Table.SelectRows, please try Table.Group suggested by CNENFRNL edhans 

     

    you need to put the code offered by CNENFRNL after your currentLookUp = [UniqueValue] like this and paste in the custom column

    =let 
  currentLookUp = [UniqueValue] 
in
  Table.Group("LookUp", "UniqueValueCol", {"Grouped", each _}){[UniqueValue=currentLookUp]}?[Grouped]?{0}?[CategoryValue]?

      

edhans's avatar
edhans
Community Champion
5 years ago

You are going to have to provide data. Help us help you. Don't ask us to make up data and work on a solution that doesn't fit your needs Anonymous - we can have 10 more posts discussing theory and ideas and get no where. 

 

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Anonymous , edhans , and CNENFRNL 

     

    I have corrected the LookUp table, you should be seeing the values now. Thanks Anonymous for notifying me.