Forum Discussion
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 |
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
2 Replies
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.
LinkedInAt 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"
