topic Re: Switch functions error in Developer

Switch functions error

22LACMT — Thu, 03 Aug 2023 16:28:23 GMT

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

Re: Switch functions error

SamInogic — Fri, 04 Aug 2023 12:28:09 GMT

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 crm@inogic.com

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

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

Re: Switch functions error

22LACMT — Fri, 04 Aug 2023 18:42:54 GMT

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.

Re: Switch functions error

SamInogic — Mon, 07 Aug 2023 06:23:51 GMT

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 crm@inogic.com

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

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

Re: Switch functions error

22LACMT — Mon, 07 Aug 2023 13:25:51 GMT

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.

Re: Switch functions error

SamInogic — Tue, 08 Aug 2023 04:10:43 GMT

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 crm@inogic.com

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

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