add previous row values in subgroup

[Anonymous]

Hi,

I have tables.

How should look DAX formula that adds the values of the previous line, it's about the earliest date for this category of data in the [Type]?

I mean like this:

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this one please

Creation2 =
CALCULATE (
    MIN ( Table1[Creation Time] ),
    FILTER (
        ALLEXCEPT ( Table1, Table1[Type] ),
        Table1[Creation Time] > EARLIER ( Table1[Creation Time] )
    )
)