Forum Discussion

22LACMT's avatar
22LACMT
Helper III
3 years ago
Solved

Switch functions error

Does anyone know why I am getting this error? and how to fix it? 

 

OverallstarRatingNR = SWITCH( ProviderInfo[Overall Rating] = "0", "Not Rated", ProviderInfo[Overall Rating] = "1", "1",ProviderInfo[Overall Rating] = "2", "2",ProviderInfo[Overall Rating] = "3", "3",ProviderInfo[Overall Rating] = "4", "4", ProviderInfo[Overall Rating] = "5", "5")
 

 

Need Help
  • SamInogic's avatar
    SamInogic
    3 years ago

    Hi 22LACMT ,

    You are actually adding ProviderInfo[Overall Rating] ="0" in your formula as mentioned above. It should be as below,

    SWITCH(ProviderInfo[Overall Rating],"0", "Not Rated","1","1","2","2","3","3","4","4","5","5")

    Let me know if you still faces the issue.

    Thanks!

     

    Inogic Professional Services Division

    Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

    Drop an email at [email protected]

    Services:  http://www.inogic.com/services/

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

5 Replies

  • SamInogic's avatar
    SamInogic
    Super User
    3 years ago

    Hi 22LACMT ,

     

    You need to use below DAX for switch case within your column,

     

    OverallstarRatingNR = SWITCH(ProviderInfo[Overall Rating],0, "Not Rated",1,"1",2,"2",3,"3",4,"4",5,"5")


    Please refer to the below screenshot,

     

     

    Thanks!

    Inogic Professional Services Division

    Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

    Drop an email at [email protected]

    Services:  http://www.inogic.com/services/

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

    • 22LACMT's avatar
      22LACMT
      Helper III
      3 years ago

      Thank you for your help!  I tried the above dax and am experiancing a new error message(below)  do you know where I should be using the value function? 

       

      Error: Dax comparison operaations do not support comparing values of type text with values of type integer. Consider using the VALUE or FORMAT function to convert one of the values. 

       

       

      • SamInogic's avatar
        SamInogic
        Super User
        3 years ago

        Hi 22LACMT  ,

         

        It seems that your “Overall Rating” column is of type text so you can try with below DAX expression,

         

        OverallstarRatingNR = SWITCH(ProviderInfo[Overall Rating],"0", "Not Rated","1","1","2","2","3","3","4","4","5","5")

         

        Please refer to the below screenshot for the same,

         

         

        Thanks!
         

        Inogic Professional Services Division

        Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

        Drop an email at [email protected]

        Services:  http://www.inogic.com/services/

        Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/