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
Icon for Super User rankSuper 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 )
    )
)