Forum Discussion

Tarek78210's avatar
Tarek78210
Frequent Visitor
2 years ago

First creation date per customer

Hi All,   I have one simple table with two columns:   - one column for the customergroup name -one column showing when that customer group was created   A customer group can have multiple cust...
Date
DAX
Tarek78210's avatar
Tarek78210
Frequent Visitor
2 years ago

Thanks very much. Is it a column measure or DAX measure? Ideally, I would like a measure I can create as a new column

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    Hi,

    The suggestion that I provided was a calculated column, not a measure.

    For creating a measure, please check the below.

     

    First Date measure =
CALCULATE (
    MIN ( Data[CreationDate] ),
    INDEX (
        1,
        SUMMARIZE ( Data, Data[CustomerGroup], Data[CreationDate] ),
        ORDERBY ( Data[CreationDate], ASC )
    )
)