Switch functions error

[22LACMT]

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")

[SamInogic]

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]

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]

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/

[22LACMT]

Hi, I feel like there is something (maybe on a formatting level) missing.  

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

I'm still experiancing the Switch fuction error : "Function switch does not support comparing values of type true/false with values of type text. consider using the Value or FORMAT function to convert on of the values. 

[SamInogic · Accepted solution]

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/