I am adding a conditional column but it doesn't include the OR criteria. Is there a way around this. I read to create another column and then pivoting/unpivoting it but it doesn't seem to quite work and wanted to avoid creating it in DAX or M if possible. Tbh I don't think there is a simple way around it using a conditional column but you may have a magic trick around it? Thank you
This is the SQL query for it which I need to put in PBI, but not very good using SWITCH me and would rather use the conditional column option if at all possible;
WHEN LET.[LETCODE_CODE]
IN ('B1CU|STMTOFACCT','GBW|BILLPRINT|CSV','S1STMT|ACCTSUMMARY','S1STMT|STMT')
THEN '1. Statement or Summary'
WHEN LEFT(LET.[LETCODE_CODE],8) = 'S1CC|1ST'
THEN '2. CC 1st Reminder'
WHEN LEFT(LET.[LETCODE_CODE],8) = 'S1CC|2ND' OR LET.[LETCODE_CODE] = 'S1CC|CLOSEDACCTDCA'
THEN '3. CC 2nd Reminder'
WHEN LEFT(LET.[LETCODE_CODE],7) = 'S1CC|IC'
THEN '4. Late Payment Reminder'
WHEN LEFT(LET.[LETCODE_CODE],16) = 'GBWCUS|COMPLAINT'
THEN '5. Complaint Correspondence'
WHEN LET.[LETCODE_CODE] IN ('S1MOVE|WELCOMECONF','S1ACQACT|WLCMPK1','S1ACQACT|WLCMPK2')
THEN '6. Welcome Pack or Letter'
WHEN LEFT(LET.[LETCODE_CODE],5) = 'S1DD|'
THEN '7. Direct Debit Letters'
WHEN LEFT(LET.[LETCODE_CODE],7) = 'S1LOSS|'
THEN '8. Customer Loss Letters'
ELSE '9. Other Communications'
END AS 'LETTER_CLASS'
This is the SQL query for it which I need to put in PBI, but not very good using SWITCH me and would rather use the conditional column option if at all possible;
WHEN LET.[LETCODE_CODE]
IN ('B1CU|STMTOFACCT','GBW|BILLPRINT|CSV','S1STMT|ACCTSUMMARY','S1STMT|STMT')
THEN '1. Statement or Summary'
WHEN LEFT(LET.[LETCODE_CODE],8) = 'S1CC|1ST'
THEN '2. CC 1st Reminder'
WHEN LEFT(LET.[LETCODE_CODE],8) = 'S1CC|2ND' OR LET.[LETCODE_CODE] = 'S1CC|CLOSEDACCTDCA'
THEN '3. CC 2nd Reminder'
WHEN LEFT(LET.[LETCODE_CODE],7) = 'S1CC|IC'
THEN '4. Late Payment Reminder'
WHEN LEFT(LET.[LETCODE_CODE],16) = 'GBWCUS|COMPLAINT'
THEN '5. Complaint Correspondence'
WHEN LET.[LETCODE_CODE] IN ('S1MOVE|WELCOMECONF','S1ACQACT|WLCMPK1','S1ACQACT|WLCMPK2')
THEN '6. Welcome Pack or Letter'
WHEN LEFT(LET.[LETCODE_CODE],5) = 'S1DD|'
THEN '7. Direct Debit Letters'
WHEN LEFT(LET.[LETCODE_CODE],7) = 'S1LOSS|'
THEN '8. Customer Loss Letters'
ELSE '9. Other Communications'
END AS 'LETTER_CLASS'