Difference from previous cell

[owlet0214]

Hello,

I want to make a custom column that calculates the difference from the previous cell.

The testedPositive is not the increasing number of people on that day, but the cumulative total up to that day.

What I want to get is the increased number of people in each city from the day before.

That's the Difference column in the table below.

I know it's not a DAX-friendly process, but please help.

[amitchandak]

@owlet0214 , prefer to create a date from the year , month and day and create two new columns like

Last date = maxx(filter(table,[city]=earlier([city]) && [Date] <earlier([Date])),[Date])
diff = [tested positive] - maxx(filter(table,[city]=earlier([city]) && [Date] <earlier([Last Date])),[tested positive])

[owlet0214]

Thanks a lot !

I haven't gotten the expected number yet, but I think it's getting closer to the correct answer.

I will try a little more.

I use below.

Last date = maxx(filter('prefectures4',[prefectureNameE]=earlier([prefectureNameE]) && [YYYYMMDD2] <earlier([YYYYMMDD2])),[YYYYMMDD2])

diff = [testedPositive] - maxx(filter('prefectures4',[prefectureNameE]=earlier([prefectureNameE]) && [YYYYMMDD2] <earlier([Last date])),[testedPositive])

[Syndicate_Admin]

Hello, I have an identical situation, and I already managed to rescue the previous value with respect to the date, but I can not do it by differentiating it by city, I do not know if you can explain to me how it was that you used the variable of [prefectureNameE] and earlier([prefectureNameE]) for this case.

Best regards.

[Greg_Deckler · Accepted solution]

Unless it is prefecture columns throwing things off I would think:

diff = [testedPositive] - maxx(filter('prefectures4',[prefectureNameE]=earlier([prefectureNameE]) && [Last date] <earlier([Last date])),[testedPositive])