Compare two rows and sum the content of those two equal rows

[paulo1978]

Hi all,

I'm a begginer with PowerBi/DAX and need help with one issue that I'm facing.

I have a table like this:

If the Name are not equal between two or more consequente rows, create a new table with only that entry

If the Name are equal, then create a new table with that Name and the sum of the Cumulative Min of those two (or more consequente rows) equal rows:

Thanks

[paulo1978]

Hi,

Yes, I can and already have done that.

Thanks

[paulo1978]

HI,

I want to compare Name from row 1 with row 2 and if they are the same, the same number, create a new table with only that Name but would like to sum the CumulativeMin in the final table:

Name                 CummulativeMin

03326789            1694.73

03326759            2781.97

03326757            2265.05

.......

.......

if the Name has 3 or more entries, then I would like to sum the CumulativeMin of the 3 or more rows and so on.

This is what I want to do. I want a final table without duplicated Names but the CumulativeMin has to be the sum of all minutes from that Name.

Thanks

[some_bih]

Hi @paulo1978 do you have option to insert index column in that table where column Name is?

[some_bih]

Hi @paulo1978 you need to check if row (Name) is the same as previous row? If yes, do you have option to insert index column in that table where column Name is? Also, provide more inputs and expected outputs.