help with basic dax

[yoav20007]

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

table 

date        item 
2/1/17     3
1/1/17     3
6/7/17     4
5/5/17     4

[Ashish_Mathur · Accepted solution]

Hi,

If you need this as a measure, then simply drag Item to the visual and write this measure

=MIN([date])

If you want a calculated column, then try this

=CALCULATE(min([date]),FILTER(data,data[Item]=EARLIER(data[Item])))

Hope this helps.

[yoav20007]

Thank 

Its help a lot.