Lookupvalue not working in one way with specific table

Hi B_kaydo 

To fix the LOOKUPVALUE issue between Table A and Table B:

1. Check for Relationships: Ensure there’s an active relationship between Table A and Table B on the Folder_name column. Without this, LOOKUPVALUE won’t work correctly.

2. Use RELATED if Relationship Exists: If there's a relationship, try using the RELATED function instead of LOOKUPVALUE:

Column in Table B = RELATED('Table A'[Folder_name])

• Ensure Matching Data Types: Make sure the Folder_name column in both tables has the same data type (e.g., text) and no inconsistencies like extra spaces.
• Handle Duplicates: If Table A contains duplicates, LOOKUPVALUE will fail. You may need to filter duplicates or use additional columns to ensure uniqueness.

• By following these steps, you should be able to resolve the issue and correctly pull values from Table A into Table B.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
YouTube: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

B_kaydo 

• Try creating a relationship between Table A and Table B based on the Folder_name column.
  Re-attempt your LOOKUPVALUE formula in Table B:

  Column = LOOKUPVALUE('Table_A'[Folder_name], 'Table_A'[Folder_name], 'Table_B'[Folder_name])

• Check the data type for the Folder_name columns in Table A and Table B. Ensure both are set to the same data type (likely Text).
• If you have established a relationship between Table A and Table B, you could use RELATED instead of LOOKUPVALUE:

  Column = RELATED('Table_A'[Folder_name])

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn