Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
how can I write the same formula in Power Bi in order to obtain the same result as shown below (integers between 1 and 5)?
new column =
switch( True()
([A]) < PERCENTILE.INC([A], 0.2) ,1,
([A]) < PERCENTILE.INC([A], 0.4) ,2,
([A]) < PERCENTILE.INC([A], 0.6) ,3,
([A]) < PERCENTILE.INC([A], 0.8) ,4,
5)
new measure =
switch( True()
max([A]) < PERCENTILE.INC([A], 0.2) ,1,
max([A]) < PERCENTILE.INC([A], 0.4) ,2,
max([A]) < PERCENTILE.INC([A], 0.6) ,3,
max([A]) < PERCENTILE.INC([A], 0.8) ,4,
5)
it seems thee is something wrong in the syntax...
([A]) < PERCENTILE.INC([A], 0.2) ,1,
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |