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 V

## Re: Creating lists / tables for AB testing

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 V

## Re: Creating lists / tables for AB testing

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

## Re: Creating lists / tables for AB testing

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

#### August Community Highlights

Check out a full recap of the month!

#### August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

#### Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors