Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

IF Statement Query

  Beginner at Power BI 🙂 Have this Issue -   Below is the query that have been using it to categorize the product type as GFT and LT (So if Product Code contains GRF,GR,GF they are tagged as GFT...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Try:

     

    Category =
SWITCH (
    TRUE (),
    CONTAINSSTRINGEXACT ( myp[Product Code], "GRF" ), "GFT",
    CONTAINSSTRINGEXACT ( myl[Session], "GR" ), "GFT",
    CONTAINSSTRINGEXACT ( myp[Product Code], "-GF" ), "GFT",
    CONTAINSSTRINGEXACT ( myp[Product Code], "TG" ), "GFT",
    CONTAINSSTRINGEXACT ( myp[Product Code], "-TG" ), "GFT",
    myp[Product Code] = "A54958", "GFT",
    "LT"
)

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Try:

 

Category =
SWITCH (
    TRUE (),
    CONTAINSSTRINGEXACT ( myp[Product Code], "GRF" ), "GFT",
    CONTAINSSTRINGEXACT ( myl[Session], "GR" ), "GFT",
    CONTAINSSTRINGEXACT ( myp[Product Code], "-GF" ), "GFT",
    CONTAINSSTRINGEXACT ( myp[Product Code], "TG" ), "GFT",
    CONTAINSSTRINGEXACT ( myp[Product Code], "-TG" ), "GFT",
    myp[Product Code] = "A54958", "GFT",
    "LT"
)