Forum Discussion

vivalimon's avatar
vivalimon
Microsoft Employee
4 years ago
Solved

TimeStamped Data - DateDiff for each unique Customer

Hi! I'd like to calculate the time it took for a person to advance from one stage to the next, and filter only those who are advancing.    INPUT I have a folder of 30+ excel files, each excel file...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    4 years ago

    vivalimon 

     

    You may use the following DAX to add a calculated table.

    Table 2 =
VAR t =
    SUMMARIZE (
        'Table',
        'Table'[Player],
        'Table'[Stage],
        "min Date", MIN ( 'Table'[Date] )
    )
RETURN
    FILTER (
        t,
        RANKX (
            FILTER ( t, 'Table'[Player] = EARLIER ( 'Table'[Player] ) ),
            'Table'[Stage],
            ,
            ASC
        ) > 1
    )

     

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
4 years ago

vivalimon 

 

You may use the following DAX to add a calculated table.

Table 2 =
VAR t =
    SUMMARIZE (
        'Table',
        'Table'[Player],
        'Table'[Stage],
        "min Date", MIN ( 'Table'[Date] )
    )
RETURN
    FILTER (
        t,
        RANKX (
            FILTER ( t, 'Table'[Player] = EARLIER ( 'Table'[Player] ) ),
            'Table'[Stage],
            ,
            ASC
        ) > 1
    )