Multiple value conditional column

[AlexisPREVOT]

Good morning,

I want to be able to create a conditional column knowing that my main column can have multiple values ​​for the same ID.
Here is an example of what I want to do.

Entreprise	Value		RESULTS ->		Entreprise	Value
A	1				A	2
A	3				B	0
B	1				C	1 and 3
B	2
B	3
C	2

How can I do this please?

[AlexisPREVOT · Accepted solution]

I have resolve my problem using CONTAINS function and a conditionnal column.
Thanks

[rajendraongole1]

Hi @AlexisPREVOT - can you please help on the result values.

A

B

C

is coming as a group but the values , how it is coming 2 , 0, 1 and 3

share with some sample data.

you can do group by in power query editor on the enterprise column. 

Conditional statement: 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[AlexisPREVOT]

Good morning @rajendraongole1 ,

You should see the results 0 1 2 3 as categories of invoiced items.

If I sell 1 and 2 then I can sell 3 to my customer.
Same, if I sell 1 and 3 then I can sell 2.

I just tried your solution but I don't see how I could make my groupings, it seems too complex to me