Creating lists / tables for AB testing

[patoduck]

Imagine you are working for a company that have, let's say  it has 10 branches. Your task is to create lists for A/B testing, so you need to prepare a new colum classifies customers in category A or B.  (Group by Bank)

So you can have a table like this.

In an Ideal world you will have even number of customer, so for eks 80 can be divided in 40 A and 40 B, but in reallity odd figures will appear so for eks 81, then it will be 40 A and 41 B.

Bank	Kunde	AB Test
A	1	A
A	2	B
A	3	A
A	4	B
A	5	A
A	6	B
A	7	A
A	8	B
A	9	A
A	10	B
A	11	A
A	12	B
A	13	A
A	14	B
A	15	A
A	16	B
B	1	A
B	2	B
B	3	A
B	4	B
B	5	A
B	6	B
B	7	A
B	8	B
B	9	A
B	10	B
B	11	A
B	12	B
B	13	A

[Mariusz · Accepted solution]

Hi @patoduck 

Sorry but I'm not sure if I understand your requirement, are you looking to create a column that alternates between a and b?
If so please consider the below solution.

=if Number.IsOdd( [Kunde] ) then "A" else "B"

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[patoduck]

At the end i did it on SQL rank () over (partition by Banknr order by CustomerNr ) as ranking and then use a  CASE with (ranking % 2) <> 0 to find odd and even numbers.

In Power BI you can do it by creating an index Group By  and then as suggested by Marius use 

Number.IsOdd  =if Number.IsOdd( [Kunde] ) then "A" else "B"