Forum Discussion

purple_ninja's avatar
purple_ninja
Regular Visitor
9 years ago

SUM function cannot work with values of type String error

Hi   I'm new to Power BI and trying to create some dashboards that show the sum of costs by category. I've followed the steps below but I cannot create a chart as I keep getting the error 'Function...
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi purple_ninja,

 

Please make sure the data you loaded to PowerBI desktop is in correct format, especially the cost column which should be number type.

 

If you have any question, please feel free to ask.

 

Best regards,
Yuliana Gu

SofG's avatar
SofG
Frequent Visitor
7 years ago

Hi,

 

I have the same problem except that the data type is already "whole number".

 

The error message says: Calculation error in measure 'XX': The function SUNX cannot work with values of type string.

 

Is there another solution to this?

 

Thanks!