Forum Discussion

ofeliajesus's avatar
ofeliajesus
Icon for Helper I rankHelper I
3 years ago
Solved

If value(another table) with Lookup

Hello I have three table    ProdCategories CatID Name Status AV1 A - AV2 B - AV3 C X AV4 D X AV5 E -   ProdInventory   ItemID Item CatID 1 AB AV1 ...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    3 years ago

    Hi ofeliajesus ,
    Please try this:

    x = IF(RELATED(ProdCategories[Status])="X", If(ISBLANK(LOOKUPVALUE(ProdRelease[Item],ProdRelease[Item],ProdInventory[Item])),"Yes","No"),"No")

     

    You said that you wanted to add a column to your table. Here is what it will look like after creating a calculated column.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
3 years ago

Hi ofeliajesus ,
Please try this:

x = IF(RELATED(ProdCategories[Status])="X", If(ISBLANK(LOOKUPVALUE(ProdRelease[Item],ProdRelease[Item],ProdInventory[Item])),"Yes","No"),"No")

 

You said that you wanted to add a column to your table. Here is what it will look like after creating a calculated column.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel