cancel
Showing results for
Did you mean:
Highlighted
Helper II

## Creating lists / tables for AB testing

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III

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.

2 REPLIES 2
Highlighted
Super User III

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.

Highlighted
Helper II

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"

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors