Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago
Solved

Lookup with Filter

Hi Good day, Can anyone assist me on my code, base from my current code i want to add filter on a specific column.   My current code: I want to add filter on coloumn: Table: BSP TA Column...
Need Help
  • AllanBerces's avatar
    AllanBerces
    2 years ago

    Hi Samarth_18 thank you for the help, its working now.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Try this

Project Name = LOOKUPVALUE('Main Data'[Project Name], 'Main Data'[Job card], 'Sign off'[Job Card] ,'Main Data'[Main Cat.],"Q",'Main Data'[Project Name],"ABCDE")

This will return a blank because there is no ABCDE entry in the Project name column.

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    2 years ago

    Hi AllanBerces ,

    You could try the following code:-

    Project Name =
LOOKUPVALUE(
    'Main Data'[Project Name],
    'Main Data'[Job card], RELATED('Sign off'[Job Card]),
    'Main Data'[Main Cat.], "Q",
    'Main Data'[Project Name], "ABCDE"
)
    • AllanBerces's avatar
      AllanBerces
      Post Prodigy
      2 years ago

      Hi Samarth_18 thank you for the help, its working now.