Forum Discussion

SandraGDS's avatar
SandraGDS
New Member
3 years ago
Solved

CurrentIndex -1

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 = '...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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.