https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Converting-a-text-string-in-a-columb-into-numbers/m-p/785625#M4285 <P>I whish to convert a column of text into numbers. The text in the column is either &lt;Active&gt;, &lt;Completed&gt; or &lt;Cannceled&gt;. I want &lt;Active&gt; to have the value 1, &lt;Completed&gt; to have the value 2 and so on.</P><P>&nbsp;</P><P>In advance, thank you!&nbsp;</P> Fri, 06 Sep 2019 10:32:32 GMT Anonymous 2019-09-06T10:32:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Converting-a-text-string-in-a-columb-into-numbers/m-p/785625#M4285 <P>I whish to convert a column of text into numbers. The text in the column is either &lt;Active&gt;, &lt;Completed&gt; or &lt;Cannceled&gt;. I want &lt;Active&gt; to have the value 1, &lt;Completed&gt; to have the value 2 and so on.</P><P>&nbsp;</P><P>In advance, thank you!&nbsp;</P> Fri, 06 Sep 2019 10:32:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Converting-a-text-string-in-a-columb-into-numbers/m-p/785625#M4285 Anonymous 2019-09-06T10:32:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Converting-a-text-string-in-a-columb-into-numbers/m-p/785678#M4288 <P>StatusCode =<BR />SWITCH ( Test[Status],</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Active", 1,</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Canceled", 2,</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Completed", 3</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)</P> Fri, 06 Sep 2019 12:14:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Converting-a-text-string-in-a-columb-into-numbers/m-p/785678#M4288 Anonymous 2019-09-06T12:14:50Z