Identify the earliest entry in a set of duplicates

[PaulCo]

Hi There

I am trying to add a column to a set of data which would identify the earliest entry based on a date field.

I have an excel spreadsheet with data that contains duplicate entries from the same customer which all have a field for when they were registered and I want to highlight the line which is the earliest entry and mark it with a column of True/False or somthing similar.

Example:

Customer	Date Registered	Earliest Record
A	6/30/2016	FALSE
A	5/30/2016	FALSE
A	1/30/2016	TRUE
B	2/3/2017	TRUE
B	8/8/2017	FALSE
A	5/28/2016	FALSE

In Excel I would use the MINISF function with some aditional columns to work it out but how would I acomplish this in Power BI?

Thanks

Paul

[Ashish_Mathur]

Hi,

Try this

=CALCULATE(MIN([Date Registered]),FILTER(data,data[Customer]=EARLIER(data[Customer])))

Hope this helps.

[KHorseman · Accepted solution]

Create a new column:

Earliest Record = IF(
    TableName[Date Registered] = CALCULATE(
        MIN(TableName[Date Registered]),
        ALLEXCEPT(TableName, TableName[Customer])
    ),
    TRUE,
    FALSE
)

[PaulCo]

Worked perfectly, thanks!