Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyLookup 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...
Hi Samarth_18 thank you for the help, its working now.
AllanBercesPost Prodigy
Post ProdigySamarth_18
Community Champion
Community ChampionHi 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
Hi Samarth_18 thank you for the help, its working now.