Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Expert
How would you apply the CF rule to the following, i am getting a erro for -250 to < -500 and so on as shown
HI @Anonymous,
I think you are write the wrong conditions, -500 should less than -250, you may need to swap the two conditions operator of the last two rules.
Regards,
Xiaoxin Sheng
The two last bounds include values that are in some of the other conditions as well. You can fix it by swapping -250 with -500, and -500 with -1000 in the two last rows.
EDIT:
If you swap the numbers, you will also need to swap some of the "<,>". The easiest might be to change it to
< -250 and >= -500
<-500 and >= -1000
User | Count |
---|---|
73 | |
69 | |
36 | |
25 | |
22 |
User | Count |
---|---|
96 | |
94 | |
53 | |
45 | |
40 |