Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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"
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"
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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |