How can I get Minimum Date For each ID and Status

[drrai66]

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

ID	Status	Changed Date	MIN Date
2303	A	11/7/2017 14:00	11/7/2017 14:00
2303	A	11/7/2017 14:01	11/7/2017 14:00
2303	A	11/7/2017 14:01	11/7/2017 14:00
2303	A	11/7/2017 14:02	11/7/2017 14:00
4657	B	11/6/2017 14:53	11/6/2017 14:53
4657	B	11/6/2017 14:53	11/6/2017 14:53
4657	B	11/8/2017 10:51	11/6/2017 14:53
4988	C	11/8/2017 11:18	11/8/2017 11:18
4988	C	11/9/2017 11:05	11/8/2017 11:18
4988	C	11/9/2017 11:08	11/8/2017 11:18
4988	C	11/9/2017 11:10	11/8/2017 11:18

[yuzarsif]

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]

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

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

[Zubair_Muhammad · Accepted solution]

@drrai66

Try this

=
CALCULATE (
    MIN ( Table1[Changed Date] ),
    ALLEXCEPT ( Table1, Table1[ID], Table1[Status] )
)

[Anonymous]

it is measeure right how we can create column

[drrai66]

Thanks, It worked!!!