Forum Discussion
Switch functions error
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/
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/
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.
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/
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.
