Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

add previous row values in subgroup

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:

 

 

 

Interesting Links
Need Help
Show and Tell
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    Try this one please

     

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

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Anonymous

     

    Try this one please

     

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