Calculated Column with a result between two values -- if statement

Question

Hello,&nbsp;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.&nbsp;Now I have done this (sorry, it won't let me insert this as Code):&nbsp;Filter_Gewichtstaffel = IF (&nbsp; &nbsp; frkostsoll[gewicht] &gt;= 0&nbsp; &nbsp; &nbsp; &nbsp; || frkostsoll[gewicht] &lt;= 1.99,&nbsp; &nbsp; "0-1,99",&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; frkostsoll[gewicht] &gt;= 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || frkostsoll[gewicht] &lt;= 4.99,&nbsp; &nbsp; &nbsp; &nbsp; "2-4,99",&nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; frkostsoll[gewicht] &gt;= 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || frkostsoll[gewicht] &lt;= 9.99,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "5-9,99",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; frkostsoll[gewicht] &gt;= 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || frkostsoll[gewicht] &lt;= 14.99,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "10-14,99",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; frkostsoll[gewicht] &gt;= 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || frkostsoll[gewicht] &lt;= 24.99,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "15-24,99",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; frkostsoll[gewicht] &gt;= 25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || frkostsoll[gewicht] &lt;= 29.99,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "25-29,99",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; frkostsoll[gewicht] &gt;= 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || frkostsoll[gewicht] &lt;= 39.99,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "30-39,99",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; frkostsoll[gewicht] &gt;= 40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || frkostsoll[gewicht] &lt;= 59.99,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "40-59,99",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; frkostsoll[gewicht] &gt;= 60&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || frkostsoll[gewicht] &lt;= 79.99,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "60-79,99",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF ( frkostsoll[gewicht] &gt;= 80, "&gt;=80", "N.v." )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ))PS: the Column is formatted as number.Can someone help me? Something is clearly wrong.&nbsp;Thanks in advanceLaura

v-jianboli-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Based on your description, I have created a simple sample:

Please try:
&nbsp;
Filter_Gewichtstaffel =
SWITCH (
    TRUE (),
    frkostsoll[gewicht] &gt;= 0
        &amp;&amp; frkostsoll[gewicht] &lt;= 1.99, "0-1,99",
    frkostsoll[gewicht] &gt;= 2
        &amp;&amp; frkostsoll[gewicht] &lt;= 4.99, "2-4,99",
    frkostsoll[gewicht] &gt;= 5
        &amp;&amp; frkostsoll[gewicht] &lt;= 9.99, "5-9,99",
    frkostsoll[gewicht] &gt;= 10
        &amp;&amp; frkostsoll[gewicht] &lt;= 14.99, "10-14,99",
    frkostsoll[gewicht] &gt;= 15
        &amp;&amp; frkostsoll[gewicht] &lt;= 24.99, "15-24,99",
    frkostsoll[gewicht] &gt;= 25
        &amp;&amp; frkostsoll[gewicht] &lt;= 29.99, "25-29,99",
    frkostsoll[gewicht] &gt;= 30
        &amp;&amp; frkostsoll[gewicht] &lt;= 39.99, "30-39,99",
    frkostsoll[gewicht] &gt;= 40
        &amp;&amp; frkostsoll[gewicht] &lt;= 59.99, "40-59,99",
    frkostsoll[gewicht] &gt;= 60
        &amp;&amp; frkostsoll[gewicht] &lt;= 79.99, "60-79,99",
    frkostsoll[gewicht] &gt;= 80, "&gt;=80",
    "N.v."
)

&nbsp;
Final output:

Best Regards,
Jianbo Li
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.&nbsp;

Forum Discussion

Calculated Column with a result between two values -- if statement

2 Replies

Related content

DAX Calculate IF OR Statement

If Statement Calculated Column Returning Incorrectly

Calculated Column If Statement

OR Statement ?

SQL Statement opcion error