Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a Calculated column where we can flag the task_id whenever there is a new date

Hello Everyone,   I am trying to create a calculated column where the column flags the task_id with 1 if there is a new date or else 0 if the date is repeated. Given below is the Table of what I am...
  • Jihwan_Kim's avatar
    5 years ago

    Hi, Anonymous 

    Please correct me if I am wrong.

    Because there are some duplicated rows in the table, I created one additional column (Index) in order to differentiate each row and compare one row with the previous row.

     

     

    Then, I created the following Calculated Column.

     

    flag task_id =
    IF (
    newtable[date]
    = CALCULATE (
    MAX ( newtable[date] ),
    FILTER ( newtable, EARLIER ( newtable[Index] ) > newtable[Index] )
    ),
    0,
    1
    )

     

    Please check if it is suitable for your task.

     

    Did I answer your question? Mark my post as a solution, this will help others!