Forum Discussion
Text comparison in power Bi
test measure = SWITCH(TRUE() ,"9.9" >= "10.5" , "#00AA00" ,"9.9" < "9.5","#FF1E00", "#BFA416" )
For the above dax it will return #00AA00 which is not same as per number comparison .How power bi compare text values?
Hi Anonymous,
In Power BI, it will compare one by one starting from the first character of the string.
For example, "9.9" vs "10.5", Power BI judges that they are strings. And the first character "9" of "9.9" is larger than the first character "1" of "10.5", so "9.9">"10.5" is true.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
3 Replies
ryan_mayuSuper User
Anonymous
maybe you can try this
test measure = SWITCH(TRUE() ,VALUE("9.9") >= value("10.5") , "#00AA00" ,value("9.9" )< value("9.5"),"#FF1E00", "#BFA416" )- amitchandak
Anonymous , In double quote, it will be a string. Try like
test measure = SWITCH(TRUE() ,9.9 >= 10.5 , "#00AA00" ,9.9 < 9.5,"#FF1E00", "#BFA416" )
- Icey
Community Support
Hi Anonymous,
In Power BI, it will compare one by one starting from the first character of the string.
For example, "9.9" vs "10.5", Power BI judges that they are strings. And the first character "9" of "9.9" is larger than the first character "1" of "10.5", so "9.9">"10.5" is true.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
