https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Using-Switch/m-p/4759307#M182247 <P>Try this&nbsp;</P><P>Status =</P><P>SWITCH(</P><P>&nbsp; &nbsp; FRAM[eligibility],</P><P>&nbsp; &nbsp; "Free", "Free",</P><P>&nbsp; &nbsp; "Reduced", "Reduced",</P><P>&nbsp; &nbsp; "Paid", "Paid",</P><P>&nbsp; &nbsp; "Other" -- optional default value</P><P>)</P> Thu, 10 Jul 2025 19:05:40 GMT Chanty4u 2025-07-10T19:05:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Using-Switch/m-p/4759302#M182246 <P>I am trying to add a new measure to a table and using data from another column to standardize some fields.</P><P>This is what I have an keep getting errors</P><P>&nbsp;</P><DIV><DIV><SPAN>Status =</SPAN> <SPAN>SWITCH</SPAN><SPAN>(</SPAN><SPAN>FRAM</SPAN><SPAN>[elgibility},'Free', "Free",'Reduced', "Reduced",'Paid')</SPAN></DIV><DIV><SPAN>TIA</SPAN></DIV></DIV> Thu, 10 Jul 2025 19:01:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Using-Switch/m-p/4759302#M182246 Anonymous 2025-07-10T19:01:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Using-Switch/m-p/4759307#M182247 <P>Try this&nbsp;</P><P>Status =</P><P>SWITCH(</P><P>&nbsp; &nbsp; FRAM[eligibility],</P><P>&nbsp; &nbsp; "Free", "Free",</P><P>&nbsp; &nbsp; "Reduced", "Reduced",</P><P>&nbsp; &nbsp; "Paid", "Paid",</P><P>&nbsp; &nbsp; "Other" -- optional default value</P><P>)</P> Thu, 10 Jul 2025 19:05:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Using-Switch/m-p/4759307#M182247 Chanty4u 2025-07-10T19:05:40Z