help with basic dax min() of date

[yoav20007]

Hi

how i can find the minimun(the first date for each item) date for each item in this tabale with dax ? 

date              item   min date?

2/1/17             3

1/1/17             3

6/7/17            4

5/5/17           4

[Ashish_Mathur · Accepted solution]

Hi,

You posted the same question here.  See my reply at than link.

[v-qiuyu-msft]

Hi @yoav20007,

You can create a measure below: 

MinDate = CALCULATE(MIN('Table1'[date]),FILTER(ALLSELECTED('Table1'),'Table1'[item]=MAX('Table1'[item]))) 

Best Regards,
Qiuyun Yu 

[yoav20007]

Thank a lot 

[Ashish_Mathur]

Hi @yoav20007.

Please mark the relevant response as Answer.