Error using if condition

Question

hi,&nbsp;i am getting the below error, can you help me?&nbsp;

edhans · Answer

Your &amp;&amp; is causing the nesting to not work right. Can you post the text of the measure vs a screenshot? I'm not going to key that in to try and replicate the syntax issue and then fix it.
&nbsp;
How to get good help fast. Help us help you.How to Get Your Question Answered QuicklyHow to provide sample data in the Power BI Forum

anonymous · Answer

Hi,&nbsp;Please try this Calculated Column&nbsp;Column&nbsp;=SWITCH&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;TRUE&nbsp;(),&nbsp;&nbsp;&nbsp;&nbsp;Procurementdata[Transaction&nbsp;Amount]&nbsp;&gt;=&nbsp;25000001,&nbsp;"&gt;$25M",&nbsp;&nbsp;&nbsp;&nbsp;Procurementdata[Transaction&nbsp;Amount]&nbsp;&gt;=&nbsp;100000000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;Procurementdata[Transaction&nbsp;Amount]&nbsp;&lt;=&nbsp;25000000,&nbsp;"$10M&nbsp;-&nbsp;$25M",&nbsp;&nbsp;&nbsp;&nbsp;Procurementdata[Transaction&nbsp;Amount]&nbsp;&lt;&nbsp;10000000,&nbsp;"&lt;$10M")&nbsp;Regards,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

v-yingjl · Answer

Hi&nbsp;vjnvinod&nbsp;,The ‘&amp;&amp;’ operator should not be used between two if() statements, just modify like this:Column = 
IF(
    'Procurementdata'[Transaction Amount] &gt;= 25000000,
    "&gt;$25M",
    IF(
        'Procurementdata'[Transaction Amount] &gt;= 10000000 &amp;&amp;
        'Procurementdata'[Transaction Amount] &lt;  25000000 ,
        "$10M-$25M",
        "&lt;$10M"
    )
)&nbsp;Best Regards,Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.

vjnvinod · Answer

v-yingjl&nbsp;&nbsp;thank you it actually worked but its not coming in orderis it possible to&nbsp; show&nbsp; that in the below order?.$25M at top $10M-$25M&lt;$10M&nbsp;

v-yingjl · Answer

Hi&nbsp;vjnvinod&nbsp;,Based on your picture, seems to order it in a slicer, right?Could not achieve it directly but you can create another column to mark each tag like a rank:Column 2 =
IF (
    'Procurementdata'[Column] = "&gt;$25M",
    1,
    IF ( 'Procurementdata'[Column] = "$10M-$25M", 2, 3 )
)Click the three dots and choose sort by column2 and sort asc&nbsp;Best Regards,Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Error using if condition

6 Replies

Related content

Conditional Formatting using DAX

Conditional formating using DAX

Conditional Replace Using Outside table

Conditional formatting using multiple calculation groups

Use WHERE condition in DAX