Forum Discussion

drrai66's avatar
drrai66
Icon for Resolver I rankResolver I
8 years ago
Solved

How can I get Minimum Date For each ID and Status

Hi All,

I would like to get the Minimum Date for Each ID and Status, So I should be getting the  Values in COLUMN (MIN Date) in following example. What is the formula to get that.

Thanks

Deepak

 

IDStatusChanged DateMIN Date
2303A11/7/2017 14:0011/7/2017 14:00
2303A11/7/2017 14:0111/7/2017 14:00
2303A11/7/2017 14:0111/7/2017 14:00
2303A11/7/2017 14:0211/7/2017 14:00
4657B11/6/2017 14:5311/6/2017 14:53
4657B11/6/2017 14:5311/6/2017 14:53
4657B11/8/2017 10:5111/6/2017 14:53
4988C11/8/2017 11:1811/8/2017 11:18
4988C11/9/2017 11:0511/8/2017 11:18
4988C11/9/2017 11:0811/8/2017 11:18
4988C11/9/2017 11:1011/8/2017 11:18
Need Help

5 Replies

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

    drrai66

     

    Try this

     

    =
CALCULATE (
    MIN ( Table1[Changed Date] ),
    ALLEXCEPT ( Table1, Table1[ID], Table1[Status] )
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      it is measeure right how we can create column

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     

    Hello all.. I want to do similar thing but I can't.. for all same 'TID', I want to create a new column name "BuyDate" and I want to get Buy Date "01.03.2019" as in the image. 

    I put following formula 

    CALCULATE(MIN(Table[Date];ALLEXCEPT(Table;Table[TID])))

     

    but I get error 

    A single value for column 'Date' in table 'Table' cannot be determined.

    • RebelCoder's avatar
      RebelCoder
      New Member
      4 years ago

      CALCULATE(MIN(Table[Date]), ALLEXCEPT(Table,Table[TID]))

       

      I believe the issue is because the first closing parethensis is in the wrong spot.