Minus Value between past date and new date with the same description

[Chanleakna123]

hi everyone ,i Unpivoted the columns and it turns like this

my purpose is : 

On 

1/26/2019 : Double fork is 7618 and On 1/27/2019 double fork is 7634 , these both will minus : Total = 7634-7618 

1/26/2019 : Double fork3 is 7346 and On 1/27/2019 double fork3 is 7357 , these both will minus : Total = 7357-7346 

How to minus the number together with the new date and past date with the same description i mentioned. i mean this will be repeatedly minus if the new date have , it will minus the old date. 

thx 

[v-shex-msft · Accepted solution]

Hi @Chanleakna123 ,

You can try to use following calculation column formula to get value diff between same attribute different date :

Diff =
VAR prev =
    CALCULATE (
        MAX ( T2[Date] ),
        FILTER (
            ALL ( T2 ),
            [Attribute] = EARLIER ( T2[Attribute] )
                && [Date] < EARLIER ( T2[Date] )
        )
    )
RETURN
    IF (
        prev <> BLANK (),
        [Value] - LOOKUPVALUE ( T2[Value], T2[Attribute], [Attribute], T2[Date], prev )
    )

Regards,

Xiaoxin Sheng

[Chanleakna123]

@v-shex-msft  , thx you dear , it works so perfectly , you're brilliant. 

[v-shex-msft]

Hi @Chanleakna123 ,

I'd like to suggest you to split attribute column to two part(description and number), it should more simply to look up similar descriptions for calculate.

If you are confused on coding formula, please share some sample data for test.

Regards,

Xiaoxin Sheng

[Chanleakna123]

@v-shex-msft  i have shared link through drop box to you. can you please assist on this ? 

Thank you 

[Chanleakna123]

hi @v-shex-msft  still awaiting your solution . can you please help me on this ? 

Thanks