Forum Discussion
Anonymous
6 years agoNot applicable
"1a" text can be convert in integer
Hi, I tested some values to convert and I saw that value("1a") return an integer, it works for all numbers (between 0 and 24) and "a". for example : 1a = 0.04 5a = 0.21 But "a" only is not a v...
AntrikshSharma
Community Champion
6 years agoAnonymous - VALUE("1a") returns 0.04 and then you can keep on replacing 1 with any number between 1 - 23 including 23. Not sure why it happens.
Anonymous
6 years agoNot applicable
- AntrikshSharma6 years ago
Community Champion
Yup only DAX gods can help now!