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

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Sounds like one of your columns is type text instead of numeric.  Check/fix that in the query editor.

 

Also, if your two tables have the same columns, you should likely Append them together in the query editor.  Add a fixed column before the append that you can use in a slicer, visual, etc..  You would then disable load on the source tables, so you only have the one table in your model (vs. those three).

 

Pat