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  ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    drrai66

     

    Try this

     

    =
CALCULATE (
    MIN ( Table1[Changed Date] ),
    ALLEXCEPT ( Table1, Table1[ID], Table1[Status] )
)
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.