Difference between two entries

Hi Theo_Alex 

Can you be more specific about the examples of computational logic, such as 2-4 = -2, where the 2 is obtained and the 4 is obtained?

---

So for instance for User_id = 1

 

The Delta of Score_ID 1 would be 2 – 4 = -2

The Delta of Score_ID 2 would be 0 – 5 = -5

And what is your expected result, a new calculated column or using a matrix to display it? If a matrix, what are the dimensions?

Hi Theo_Alex 

Would the following measures help?

Score = SUM( 'FactTable'[Score] )

Prev = 
    CALCULATE(
        [Score],
        OFFSET(
            -1,
            ORDERBY( 'FactTable'[Entry_Date], ASC ),
            PARTITIONBY( FactTable[User_ID] )
        )
    )

Diff = [Score] - [Prev]

Let me know if you have any questions.

Difference between 2 entries.pbix

Hi Theo_Alex ,

First of all, many thanks to gmsamborn  for your very quick and effective replies.

Based on my testing, please try the following methods:

1.Create the simple table.

2.Create the new measure to calculate score for last entry.

Last Entry = 
var entr_i = MAX('Table'[Entry_ID])
var _Max = CALCULATE(MAX('Table'[User_ID]), FILTER('Table', 'Table'[Entry_ID] = entr_i))
Return
Calculate(SUM('Table'[Score]),filter(ALLEXCEPT('Table', 'Table'[Score_ID]), 'Table'[User_ID] = _Max  && 'Table'[Entry_ID] > entr_i ))

3.Create the new measure to the difference between two entries.

Difference two entres = IF(ISBLANK([Last Entry]), BLANK(), [Last Entry] - SUMX('Table', 'Table'[Score]))

4.Drag two measure into the table visual. The result is shown below.

Best Regards,

Wisdom Wu

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