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]

     

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi Anonymous ,

 

First of all, pay attention to your yellow mark is wrong. According to your description, you want to get the value of 1,0 corresponding to TaskBaselineDuration column corresponding to row subtraction under the same TaskID column. I did the following test to create the Subtract_ Result measure: if the ID is the same and the BaselineNumber is 1,0, then the corresponding rows in the TaskBaselineDuration column will be subtracted, otherwise the value will not change.

Here is the sample pbix file.


Best Regards,
Henry

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.