IF Statement Query

[Anonymous]

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 and otherwise LT)

Existing working Query-

Product Type = if((not(isERROR(find("GRF",myp[Product Code],1))) || not(IsERROR(find("GR",myl[Session],1))) || not(IsERROR(find("-GF",myp[Product Code],1)))),"GFT",if(myp[Product Code]="A54958","GFT","LT"))

Apart from the existing codes for GFT , i also need  to add Product Code "TG" or "-TG"  as GFT. Have been trying to edit this into the existing query. But having issues.

Kindly suggest

[Anonymous]

Thanks Paul for your quick help

[PaulDBrown · Accepted solution]

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"
)