Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Subtract Between Rows with Same ID

Hi Team, I want to subtract rows with the same Id. Example is what i'm highlighting. Some TaskIDs are unique, some don't. Unique TaskID: We don't do anything. NOT Unique TaskId, i want to subtract...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    Not sure if one ID will have only one baseline 1 or 0. if so ,you can try to create a new column.

    Column = MAXX(FILTER('Table1',Table1[Task ID]=EARLIER(Table1[Task ID])&&Table1[baseline]=0),Table1[TaskBaselineDuration])-Table1[TaskBaselineDuration]

     

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Anonymous 

Not sure if one ID will have only one baseline 1 or 0. if so ,you can try to create a new column.

Column = MAXX(FILTER('Table1',Table1[Task ID]=EARLIER(Table1[Task ID])&&Table1[baseline]=0),Table1[TaskBaselineDuration])-Table1[TaskBaselineDuration]

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you so much. Your instructions are awesome and work for my case.