if statement help
1 Topic
IF statement and conditions
Hello, what would be the best way to run both these in DAX within the same statement. Switch / nested? I can't quite work it through, grateful for pointers as a newbie. Although only 2 conditions (at the moment), and looked at OR || as well, not sure on most appropriate method. IF(CONTAINSSTRING(Table[CompanyNumber],"Company2"),IF(Table[Letter Received]="No" && ISBLANK(Table[Responded], IF(Table[CompanyNumber]<>"Company2"),IF(Table[Letter Received]<>"No" && ISBLANK(Table[Responded]), "Check", "Pass" )Solved974Views0likes5Comments