Compare with previous visit and calculate it in Matrix visual

[chotu27]

Hi Everyone,

In below picture i wanted to compare it with prevous visit and calculate it.

Can i know the DAX calculation for it please

Example : For ID 1001 Visit2- Visit1 = 22-23 = -1.

[Phil_Seamark · Accepted solution]

HI @chotu27

I had some luck with this calculated column and have attached a PBIX file at the bottom.

Column = 
VAR VisitNumber = INT(MID('Table1'[Memory],7,99))
VAR LastValue = MAXX(FilTER('Table1','Table1'[Memory] = "Visit " & VisitNumber-1 && 'Table1'[ID] = EARLIER('Table1'[ID])),'Table1'[Value])
RETURN IF(NOT ISBLANK(LastValue),'Table1'[Value] - LastValue)