CurrentIndex -1

[SandraGDS]

Hi 

I need help, i want to say "if the ProcessNumber currentIndex -1 does'nt exist then -1 again untill found"

Timestamp =

VAR CurrentCase = 'Export Worksheet'[Order]

VAR CurrentIndex = 'Export Worksheet'[ProcessNumber]

VAR PreviousIndex = CurrentIndex - 1

RETURN

    CALCULATE (

        SELECTEDVALUE ( 'Export Worksheet'[DATE]),

        REMOVEFILTERS ( 'Export Worksheet'),

       'Export Worksheet'[Order] = CurrentCase,

        'Export Worksheet'[ProcessNumber] = PreviousIndex)

[v-jingzhang · Accepted solution]

Hi @SandraGDS 

Please use this measure:

Timestamp =
VAR CurrentCase = 'Export Worksheet'[TRAY_NO]
VAR CurrentIndex = 'Export Worksheet'[STTN_NO_R]
VAR PreviousIndex =
    CALCULATE (
        MAX ( 'Export Worksheet'[STTN_NO_R] ),
        REMOVEFILTERS ( 'Export Worksheet' ),
        'Export Worksheet'[TRAY_NO] = CurrentCase,
        'Export Worksheet'[STTN_NO_R] < CurrentIndex
    )
RETURN
    CALCULATE (
        SELECTEDVALUE ( 'Export Worksheet'[AMD_DATE] ),
        REMOVEFILTERS ( 'Export Worksheet' ),
        'Export Worksheet'[TRAY_NO] = CurrentCase,
        'Export Worksheet'[STTN_NO_R] = PreviousIndex
    )

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[SandraGDS]