How to get difference of sold qty each item compared to previous sold date

[ajinwlee]

Hello,

I would like to get difference of sold qty each item compared to previous sold date.

like follwing tables.

Thank you,

[ajinwlee]

Thanks a lot.  It helps me to understand DAX functions.

[Ritaf1983]

I was glad to be of assistance 🙂

[Ritaf1983 · Accepted solution]

Hi @ajinwlee .
Try to dd a column with attached Dax formula :

diff row =

[Value]

    - LOOKUPVALUE (

        'Table'[Value],

        'Table'[Category], [Category],

        'Table'[Date],

            CALCULATE (

                MAX ('Table'[Date] ),

                FILTER (

                    'Table',

                    'Table'[Category] = EARLIER ( 'Table'[Category])

                        &&'Table'[Date]  < EARLIER ( 'Table'[Date] )

                        && 'Table'[Date] <> BLANK ()

                )

            )

    )

Link To Sample File 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.