Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

the sum of string

Hi,

 

I have tried about 3 different dax ways and non of them work.

I have a direct query where the number is stored as a string

I need to create a measure that sums the cost.

 

simples

  • Anonymous's avatar
    Anonymous
    4 years ago

    Anonymous 

    See example.

     

    Measure = SUMX('Table',VALUE(MAX('Table'[Column1])))

     

     

    Best regards
    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks for all the replys, I ended up having to import the data in the end due to other changes that were required 

4 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous 

     

    Use CONVERT DAX function and convert those data to Currency:

    CONVERT('Table'[Cost]),CURRENCY)
     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!


  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous 

    See example.

     

    Measure = SUMX('Table',VALUE(MAX('Table'[Column1])))

     

     

    Best regards
    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for all the replys, I ended up having to import the data in the end due to other changes that were required