Forum Discussion
Solved
Custom column help needed
segment1 Category 2000 Air Transportation 2000 Donor Tissue Typing 2000 Ground Transportation 2000 Hospital & Physician Costs 3000 Air Transportation 3000 Hospital & Physi...
csolanky your code works fine for me I am not getting any errors.
Categories is just a step I created to remove redundancy of the same list
= {"Hospital & Physician Costs","Surgeon Fees","Ground Transportation","Air Transportation","Serology","Donor Tissue Typing","Recovery Supplies","Other Organ Expenses"}
Hey csolanky could you try swicth instead?
SWITCH (
TRUE,
List.Contains({"Hospital & Physician Costs","Surgeon Fees","Ground Transportation","Air Transportation","Serology","Donor Tissue Typing","Recovery Supplies","Other Organ Expenses"}, [Category]) && [segment1] = 2000, "Direct Organ",
List.Contains({"Hospital & Physician Costs","Surgeon Fees","Ground Transportation","Air Transportation","Serology","Donor Tissue Typing","Recovery Supplies","Historical Year Discards","Other Tissue Expenses"}, [Category]), "Direct Tissue",
"Other"
)
might do the trick!
BiAnalyst SWITCH isn't a function in M language.
