Forum Discussion
Creating a List of Records Based on a Measure
Hi Matt0515 ,
According to your example, you could try SWITCH() function.
SWITCH ( TRUE (), AND ( OR ( 'Table'[Column X] = "a", 'Table'[Column X] = "b" ), 'Table'[Column Y] = "xyz" ), "Business Unit 1", AND ( OR ( 'Table'[Column X] = "c", 'Table'[Column X] = "d" ), 'Table'[Column Y] = "abc" ), "Business Unit 2" )
amitchandakAllow me to rephrase:
I have a dataset where I need to identify what business unit each row belongs to.
the definition of each business unit is diffirent than the next.
I would like to create a custom column that will result in the business unit for each row.
The example above would define a specific business unit and the paramiters would change for the next business unit ( and so on )
Where I am struggling is how to structure the Custom Column code to accept multiple paramiters to achieve a single column with multiple results.
example:
IF Column X = "a" OR "b", AND Column Y = "xyz" THEN "Business Unit 1"
OR / ELSEIF
IF Column X = "c" OR "d", AND Column Y = "abc" THEN "Business Unit 2"
Hopefully this makes more sense. I'm ultimatly attempting to make a single column of multiple resuts based on rules that identify exclusive rows.
Thanks
Community SupportHi Matt0515 ,
According to your example, you could try SWITCH() function.
SWITCH (
TRUE (),
AND (
OR ( 'Table'[Column X] = "a", 'Table'[Column X] = "b" ),
'Table'[Column Y] = "xyz"
), "Business Unit 1",
AND (
OR ( 'Table'[Column X] = "c", 'Table'[Column X] = "d" ),
'Table'[Column Y] = "abc"
), "Business Unit 2"
)