Forum Discussion
bookhouseboy
Helper I
Helper IUsing SWITCH in a table to evaluate only one row at a time
Hi, so we're trying to visualize changes in a table by adding little arrows, indicating whether an item has moved up or down since yesterday. We have a measure called #arrow that is supposed to indic...
bhanu_gautam
Super User
Super Userbookhouseboy , Try using
#arrow =
SWITCH(
TRUE(),
SELECTEDVALUE(X[DeltaRang]) < 0, UNICHAR(9207), // Negative
SELECTEDVALUE(X[DeltaRang]) = 0, UNICHAR(9205), // Null
SELECTEDVALUE(X[DeltaRang]) > 0, UNICHAR(9206), // Positive
UNICHAR(9210)
)
bookhouseboyHelper I
Helper IThanks but, no, we tried that -- no change. ☹️