Forum Discussion
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 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
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" )
2 Replies
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" )