conditional format

[khisla]

I have the below visual and want to create a conditional format

If the transactio No. is Transaction No +1 of the previous row (for difference store number) to have an icon with a red circle.

For example, in my below data transaction # 145571 + #145572 would have a red circle icon while the others would be green.

My data is filtered on currency therefore not sure if that would impact the conditional formating.

Thanks in advance

[khisla]

Quick question.

This solution worked however it is not marking the first item in the series.

For example the above transactions 145571 + 145572 are marked as red however not 145570.

How can I modify the formula so that 145570 will also be flagged as red.

[khisla]

Thanks you so much.  The solution worked.

[Fowmy · Accepted solution]

@khisla 
Not sure if you need the solution as follows:

Flag = 
VAR __PrevTrxNo = 
    MAXX(
        OFFSET( 
            -1 ,
            SUMMARIZE(ALLSELECTED(Table01) , Table01[Store No.] , Table01[Transaction No.] ),         
            ORDERBY( Table01[Transaction No.]  )
        ),
        Table01[Transaction No.]
    )
VAR __CurrTrxNo = SELECTEDVALUE(Table01[Transaction No.])
VAR __Result = INT(__PrevTrxNo + 1 = __CurrTrxNo)
RETURN
    __Result