SQL code

[Anonymous]

I have below table as input

id|type
1|manager
1|non manager
1|manager
1|non manager
1|non manager
1|manager

desired output: if more than one id falling into manager and non manager hen it should show as mixed as shown below.

id|type
1|mixed

Can anyone help ..

[vik0810 · Accepted solution]

Hi @Anonymous,

do you need SQL or DAX?

If SQL, you can use following query:

SELECT 
	id,
	CASE WHEN COUNT(DISTINCT type) > 1 THEN 'mixed' ELSE MIN(type) END "Type"
FROM YourTable
GROUP BY ID

[Anonymous]

You should try using a case when switch in sql counting the number of unique type if it is highter than one then mixed