Forum Discussion

Bach's avatar
Bach
Frequent Visitor
3 years ago
Solved

Comparing Different Line Values Based on the Date and ID

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!

 

Need Help
  • DataInsights's avatar
    DataInsights
    3 years ago

    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

     

     

1 Reply

  • DataInsights's avatar
    DataInsights
    Super User
    3 years ago

    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