Comparing Different Line Values Based on the Date and ID

[Bach]

Hello, people 😄

I need some help in the following situation. Let's suppose I have many IDs, that have their updated date that this ID have changed his Item. How can I create a new column that says TRUE when the oldest Item is equal to the newest Item for each ID and FALSE when it doens't happen?

Let's visualize it:

I thank you so much!

[DataInsights · Accepted solution]

@Bach,

Try this calculated column:

Result = 
VAR vID = Table1[ID]
VAR vTableCurrentID =
    FILTER ( Table1, Table1[ID] = vID )
VAR vOldestDate =
    MINX ( vTableCurrentID, Table1[LastUpdate] )
VAR vNewestDate =
    MAXX ( vTableCurrentID, Table1[LastUpdate] )
VAR vOldestItem =
    CALCULATE (
        MAX ( Table1[Item] ),
        vTableCurrentID,
        Table1[LastUpdate] = vOldestDate
    )
VAR vNewestItem =
    CALCULATE (
        MAX ( Table1[Item] ),
        vTableCurrentID,
        Table1[LastUpdate] = vNewestDate
    )
VAR vResult =
    IF ( vOldestItem = vNewestItem, TRUE, FALSE )
RETURN
    vResult