Forum Discussion
Dax Compairing values of text with integer error
Hi Experts I have created 2 measure Currentlessprevuous= Var Red = UNICHAR (9660) Var Green =UNICHAR (9650) return If([c]-[p]>0,Green,Red) Arrow=if([Currentlessprevious]>0,1,0) When i ...
Hi Anonymous ,
According to my understanding, you want to set
c-p>0 : Green Arrow
c-p<0: Red Arrow
You could try this measure:
Measure = IF ( MAX ( 'Table'[c] ) - MAX ( 'Table'[p] ) > 0, "Green", "Red" )And apply it to Conditional Formatting as shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
According to my understanding, you want to set
c-p>0 : Green Arrow
c-p<0: Red Arrow
You could try this measure:
Measure =
IF ( MAX ( 'Table'[c] ) - MAX ( 'Table'[p] ) > 0, "Green", "Red" )And apply it to Conditional Formatting as shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.