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,

3 Replies

  • mattbrice's avatar
    mattbrice
    Solution Sage
    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
    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,