Calculating difference between consecutive rows

Hi socksinbox ,

It can be segment wise, you just create a table and drag the segment column into it,

then create the measue I did, then drag to it, you will see the result.

Or do you mean you want to use a DAX to create a new table with segment column and diff column?

Aiolos Zhao

Hi socksinbox ,

If you want to create a new table, please use below expression :

Table = SUMMARIZE(Table4,Table4[Segment],"Diff",CALCULATE(COUNTROWS(Table4),Table4[PeopleType] = "Active") - CALCULATE(COUNTROWS(Table4),Table4[PeopleType] = "Negative"))

Thanks.

Aiolos Zhao

Hi,

Based on the data that you have shared, the average should be 0.  Try this measure

Measure = AVERAGEX(SUMMARIZE(CALCULATETABLE(Data,Data[PeopleType]="Active"||Data[PeopleType]="Negative"),Data[Segment],"Active",CALCULATE(COUNTROWS(Data),Data[PeopleType]="Active"),"Negative",CALCULATE(COUNTROWS(Data),Data[PeopleType]="Negative")),[Active]-[Negative])