Forum Discussion

dsabsi's avatar
dsabsi
Icon for Advocate I rankAdvocate 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

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi dsabsi,

 

Could you post some sample data(no need to post the real data, just some letters or random numbers like below) and your expected result? So that we can better assist on this issue. :smileyhappy:

 

Table1

column1 column2
a 1
b 2
c 3

 

Expect Result: Total of 'column2': 6

 

Regards

dsabsi's avatar
dsabsi
Icon for Advocate I rankAdvocate I
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