Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am currenctly trying to write a calculated column to Filter Visuals.
I would like to use it to filter what weight range a shipment is in.
Now I have done this (sorry, it won't let me insert this as Code):
PS: the Column is formatted as number.
Can someone help me? Something is clearly wrong.
Thanks in advance
Laura
Solved! Go to Solution.
Hi @Laura0403 ,
Based on your description, I have created a simple sample:
Please try:
Filter_Gewichtstaffel =
SWITCH (
TRUE (),
frkostsoll[gewicht] >= 0
&& frkostsoll[gewicht] <= 1.99, "0-1,99",
frkostsoll[gewicht] >= 2
&& frkostsoll[gewicht] <= 4.99, "2-4,99",
frkostsoll[gewicht] >= 5
&& frkostsoll[gewicht] <= 9.99, "5-9,99",
frkostsoll[gewicht] >= 10
&& frkostsoll[gewicht] <= 14.99, "10-14,99",
frkostsoll[gewicht] >= 15
&& frkostsoll[gewicht] <= 24.99, "15-24,99",
frkostsoll[gewicht] >= 25
&& frkostsoll[gewicht] <= 29.99, "25-29,99",
frkostsoll[gewicht] >= 30
&& frkostsoll[gewicht] <= 39.99, "30-39,99",
frkostsoll[gewicht] >= 40
&& frkostsoll[gewicht] <= 59.99, "40-59,99",
frkostsoll[gewicht] >= 60
&& frkostsoll[gewicht] <= 79.99, "60-79,99",
frkostsoll[gewicht] >= 80, ">=80",
"N.v."
)
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Laura0403 ,
Based on your description, I have created a simple sample:
Please try:
Filter_Gewichtstaffel =
SWITCH (
TRUE (),
frkostsoll[gewicht] >= 0
&& frkostsoll[gewicht] <= 1.99, "0-1,99",
frkostsoll[gewicht] >= 2
&& frkostsoll[gewicht] <= 4.99, "2-4,99",
frkostsoll[gewicht] >= 5
&& frkostsoll[gewicht] <= 9.99, "5-9,99",
frkostsoll[gewicht] >= 10
&& frkostsoll[gewicht] <= 14.99, "10-14,99",
frkostsoll[gewicht] >= 15
&& frkostsoll[gewicht] <= 24.99, "15-24,99",
frkostsoll[gewicht] >= 25
&& frkostsoll[gewicht] <= 29.99, "25-29,99",
frkostsoll[gewicht] >= 30
&& frkostsoll[gewicht] <= 39.99, "30-39,99",
frkostsoll[gewicht] >= 40
&& frkostsoll[gewicht] <= 59.99, "40-59,99",
frkostsoll[gewicht] >= 60
&& frkostsoll[gewicht] <= 79.99, "60-79,99",
frkostsoll[gewicht] >= 80, ">=80",
"N.v."
)
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jianbo Li,
thanks a lot. I don't know why I haven't thought about the switch.
I guess my brain had some problems that day 😄
Now it works, thanks a lot.
Laura 🙂
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |