Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

IF excel has vlookup code , it will get error when import in Power BI

i have one excel with several sheet , one column A in sheet A using vookup column B in sheet B in same excel as first  picture , when i import it in Power BI , that column A return error as second pi...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi Anonymous ,

 

You can either:

  • right click the column header and click replace error. You can replace it with null by typing null or replace it with any other value
  • or you can remove rows with errors which, of course, will remove the entire row altogether.

  •  

Anonymous's avatar
Anonymous
Not applicable
2 years ago

but can i use vlook code when click replace error , and when i writing vlookup , the system does not show this code , it seems not avaliable in Power BI . 

 

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    Although the DAX functions are  similar to those of Excel, there is no  VLOOKUP in Power BI. Look into using LOOKUPVALUE. If the tables have a direct relationship and you are trying to create a calculated column from the many side of o a one-to-many relationship, you can use RELATED function. Note: LOOKUPVALUE expects a single result - unlike in Excel, it won't pickup the first match - it will throw an error.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      oK，it may difficult for me to understand , let me do example :

      1. i have import sheet A , with column A ; sheet B with column A and B in power BI ;

      2, Now i want create column B in sheet A based on colunmn A ,  that means A1 value in sheet A , then system look for A1 value in sheet B , find the related B value , then return to B1 in sheet A . so how to modify qury .