Forum Discussion

dsabsi's avatar
dsabsi
Advocate I
9 years ago
Solved

Error: The function SUM can not work with values of type String

Hi all,    I'm new to Power BI and I'm trying to visualize my IF-formula but I'm getting this error:  The function SUM cannot work with values of type String.  I tried to remove the sum from my f...
Need Help
  • dsabsi's avatar
    dsabsi
    9 years ago

    Hi guys, 

     

    I found the solution!

    I created a new measure, while it should be new column with the same If-formula and now it works =D I'm really happy!!

    I do want to emphasize my gratitude for your swift replies, I'm really blown away how many people are willing to help :). 

     

    Many thanks and have a great day!

     

    Cheers

dsabsi's avatar
dsabsi
Advocate I
9 years ago

Hello MFelix, 

 

I really appreciate your swift reply!

I tried to use your formula as measure but it gives me the following 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 one of these values.

 

Both columns to which I'm referring are Text (data type and format), so there is no E icon before my columns. 

Moreover, I can't change the data type of my measure, do you have any idea how I can show my if-formula in another way or perhaps I'm doing something wrong with your proposed solution :).


Any help is really appreciated! 

 

Cheers

 

MFelix's avatar
MFelix
Super User
9 years ago

HI dsabsi,

 

If you are using Text fields you cannot use the Sum function, why are you comparing text strings with sum? Can you proveid a little bi more detail on the values / data you have in your columns?

 

Regards,

MFelix