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 sa...
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

     

     

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