compare previous value

Question

What is the efficient dax to compare current value to previous value to derive up and down arrows ?&nbsp;Input Table&nbsp;City&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Station&nbsp; &nbsp;Measurement&nbsp; Time&nbsp;Brooklyn&nbsp; &nbsp;S1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08/27/2020 7:00 am&nbsp;Brooklyn&nbsp; &nbsp;S1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08/27/2020 7:30 am&nbsp;Brooklyn&nbsp; &nbsp;S1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08/27/2020 8:00 am&nbsp;Brooklyn&nbsp; &nbsp;S1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08/27/2020 8:30 am&nbsp;Brooklyn&nbsp; &nbsp;S1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08/27/2020 9:00 am&nbsp;Brooklyn &nbsp;S2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08/27/2020 7:30 am&nbsp;Brooklyn &nbsp;S2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08/27/2020 8:00 am&nbsp;Brooklyn &nbsp;S2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08/27/2020 8:30 am&nbsp;&nbsp;Output &nbsp;Brooklyn S1 Down Arrow&nbsp;Brookyn S2 Up Arrow

fowmy · Accepted Answer

curiouspbix0&nbsp;Please try this measure; you can also use the Icon Set in Conditional Formatting with slight modIfication to this measure.&nbsp;&nbsp;UpDown = 
VAR D = MAX(Brooklyn[Time ])
VAR PD=
    CALCULATE(
        MAX(Brooklyn[ Measurement ]),
       Brooklyn[Time ] &lt; D
    )
VAR DIF = 
IF( 
    ISBLANK(PD), BLANK(),
    
    IF ( MAX(Brooklyn[ Measurement ]) - PD &gt;= 0 , UNICHAR ( 9650 ), UNICHAR ( 128315 ))
)

RETURN
DIF&nbsp;&nbsp;________________________If my answer was helpful, please consider Accept it as the solution to help the other members find itClick on the Thumbs-Up icon if you like this reply 🙂YouTube&nbsp; LinkedIn&nbsp;

Forum Discussion

compare previous value

2 Replies

Related content

Comparing values to previous months

Comparing latest value to previous

DAX query to compare previous values

Getting value for previous year based on value name and year slicer

Compare values from previous rows