cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
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.

 

 

BankKundeAB Test
A1A
A2B
A3A
A4B
A5A
A6B
A7A
A8B
A9A
A10B
A11A
A12B
A13A
A14B
A15A
A16B
B1A
B2B
B3A
B4B
B5A
B6B
B7A
B8B
B9A
B10B
B11A
B12B
B13A

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User V
Super User V

Re: Creating lists / tables for AB testing

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"


image.png

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn



 

View solution in original post

2 REPLIES 2
Highlighted
Super User V
Super User V

Re: Creating lists / tables for AB testing

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"


image.png

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn



 

View solution in original post

Highlighted
Helper II
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"

 

Helpful resources

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