Sum by codebook

[nikca]

Hello guys, 

i have two tables: 

Table 1
Text	Number
010010	10,5
011000	11
210100	250

Table 2
Category	Text
010	010010
011	011000
210	210100

In table 1, I using Measure, to sum all numbers related to text (text are more times in table). 

Table 2 is codebook to text. 

All i need is to get different for example between 010-011, which is -0,5. 

But, I don´t know how. 

[Ritaf1983 · Accepted solution]

Hi @nikca 
You can achieve it using offset fumction

The steps :

2. Calculate basic sum

Sum_number = sum('Table'[Number])

3. Calculate your needed delta

ValuesDiff =

[Sum_number] - CALCULATE (

        [Sum_number],

        OFFSET ( -1, ALLSELECTED ( 'Table (2)'[Category] ), ORDERBY ( 'Table (2)'[Category], ASC ) )

    )

Link to a sample file 

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