topic Re: the sum of string in DAX Commands and Tips

the sum of string

Anonymous — Fri, 29 Oct 2021 20:22:12 GMT

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

VahidDM — Fri, 29 Oct 2021 22:35:07 GMT

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!!

CNENFRNL — Sat, 30 Oct 2021 09:41:31 GMT

Anonymous — Wed, 03 Nov 2021 02:30:53 GMT

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 — Fri, 05 Nov 2021 09:17:31 GMT

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