Forum Discussion

Caiz's avatar
Caiz
Frequent Visitor
5 years ago
Solved

Using Measures: The function SUM cannot work with values of type String

Hi there,   I have two excel tables I've imported with the same columns to show as a table for each within Power BI. I have replicated code for a Measure that will display the variance between two ...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    Hi Caiz -

     

    Check the data types in "Transform Data" for your NEW Expenditure table. Likely one or more of the columns is being treated as "Text" or "Any" because some value prevented it from being recognized as a number all the way down.

     

    The ' ' around NEW Expenditure is because of the space in the table name. If you named it New_Expenditure or NewExpenditure it would not have the ' '.

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Community Champion
5 years ago

Hi Caiz -

 

Check the data types in "Transform Data" for your NEW Expenditure table. Likely one or more of the columns is being treated as "Text" or "Any" because some value prevented it from being recognized as a number all the way down.

 

The ' ' around NEW Expenditure is because of the space in the table name. If you named it New_Expenditure or NewExpenditure it would not have the ' '.

 

Hope this helps

David