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.

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.