Forum Discussion

yoav20007's avatar
yoav20007
Helper II
8 years ago
Solved

basic dax find minimun date

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
  • mattbrice's avatar
    mattbrice
    8 years ago

    As a calculated column:

     

    = CALCULATE ( MIN (Table[date]), ALLEXCEPT ( Table[item] ) )

     

    as  a measure it depends on other filters in place. 

  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    yoav20007

     

    Adding to mattbrice's answer, please put table first, then column in ALLEXCEPT()

     

    Measure = CALCULATE(MIN(Table1[Date]),ALLEXCEPT(Table1,Table1[Item]))

     

    And make sure your Item column is not summarized.

     

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

yoav20007

 

Adding to mattbrice's answer, please put table first, then column in ALLEXCEPT()

 

Measure = CALCULATE(MIN(Table1[Date]),ALLEXCEPT(Table1,Table1[Item]))

 

And make sure your Item column is not summarized.

 

 

Regards,

  • yoav20007's avatar
    yoav20007
    Helper II
    8 years ago

    Thank