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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi AllanBerces ,

 

As I understand it, you want to filter the table based on two column values and then use the LOOKUPVALUE later.

Please try as followings:

 

Base_Scope =
VAR ProjectName =MAX('BSP TA'[Project Name])
VAR MainCat = MAX('BSP TA'[Main Cat.])
VAR JobCard = MAX('BSP TA'[Job card])
RETURN
    IF(
        ProjectName = "ABCDE" && MainCat = "Q",
        IF(
            ISBLANK(
                LOOKUPVALUE(
                  sign_off[sign off],
                    sign_off[Job Card],
                    JobCard
                )
            ),
            "Injected",
            LOOKUPVALUE(
                sign_off[sign off],
                sign_off[Job Card],
                JobCard
            )
        ),
        BLANK()
    )

 

Sample data from the sign-off table:

 

Before:

After:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.