Switch / Case multiple results
Hello all, I'm attempting to make an "error message" column in a table that can read multiple criteria and result the reasons there's an error message for the given project (rows in the table). I've found that Switch( True(),... ) only wants to find one criteria but I have overlapping cases where more than one case is true. Here's generally what I've got so far: Error Message = SWITCH( TRUE(), 'Data'[Start_Date]=BLANK(),"Start Date is blank", 'Data'[Status]="Red","Status is Red", //among several dozen other columns "No Errors") What's my alternative since if/elif doesn't seem to be availabile in dax? Any ways to cycle back through the cases? Ultimately I'd like to find a way to concatenate the various error messages with commas into a single column (per row) in a table. Any ideas from the community? Thanks.