Forum Discussion
curiouspbix0
Helper IV
Helper IVcompare previous value
What is the efficient dax to compare current value to previous value to derive up and down arrows ? Input Table City Station Measurement Time Brooklyn S1 1.3 ...
curiouspbix0
Please try this measure; you can also use the Icon Set in Conditional Formatting with slight modIfication to this measure.UpDown = VAR D = MAX(Brooklyn[Time ]) VAR PD= CALCULATE( MAX(Brooklyn[ Measurement ]), Brooklyn[Time ] < D ) VAR DIF = IF( ISBLANK(PD), BLANK(), IF ( MAX(Brooklyn[ Measurement ]) - PD >= 0 , UNICHAR ( 9650 ), UNICHAR ( 128315 )) ) RETURN DIF________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super Usercuriouspbix0
Please try this measure; you can also use the Icon Set in Conditional Formatting with slight modIfication to this measure.
UpDown =
VAR D = MAX(Brooklyn[Time ])
VAR PD=
CALCULATE(
MAX(Brooklyn[ Measurement ]),
Brooklyn[Time ] < D
)
VAR DIF =
IF(
ISBLANK(PD), BLANK(),
IF ( MAX(Brooklyn[ Measurement ]) - PD >= 0 , UNICHAR ( 9650 ), UNICHAR ( 128315 ))
)
RETURN
DIF
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂