Column =
SWITCH (
TRUE (),
'Table'[Field1] = "AAA", "RETAIL",
'Table'[Field1] = "BBB", "ONLINE",
SEARCH ( "CCC", 'Table'[Field2], 1, 0 ) = 1, and 'Table'[Field1] like '%yyy%', "RETAIL",
'Table'[Field2] = "DDD", "RETAIL",
"UNKNOWN"
)
No comments:
Post a Comment