Condition with AND

Question

Hi,&nbsp;&nbsp;I am trying to create new column based on a previous one based with the condition if less then 10 = 1 ; if between 10 and 49 = 2 ; and if great then 50 = 3.&nbsp;The desired output would be:Item&nbsp;Total&nbsp;NewVariableProduct A11Product B242Product C482Product D563&nbsp;The code I am using is:&nbsp;NewVariable = SWITCH(TRUE(),'Value'[Total] &lt;= 10,Value(1),'Value'[Total] &gt; 10 and 'Value'[Total] &lt;50,Value(2),'Value'[Total] &gt;= 50,Value(3),-1)&nbsp;but it is not working any thoughts how I could overpass this?Thanks,

anonymous · Accepted Answer

Hi&nbsp;Giovani&nbsp;,&nbsp;Try this code.&nbsp;Column = SWITCH(True(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Value'[Total ]&lt;=10,1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Value'[Total ]&gt;10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; 'Value'[Total ]&lt;50, 2, 'Value'[Total ]&gt;=50,3,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -1)&nbsp;&nbsp;&nbsp;It has worked for me and here is my output:&nbsp;&nbsp;

Forum Discussion

Condition with AND

1 Reply

Related content

Rank with conditions

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Item	Total	NewVariable
Product A	1	1
Product B	24	2
Product C	48	2
Product D	56	3