Difference between dates

[panchinxd]

Hey guys! so i have a problem, lets think about if i have this table:

Date	Amount
10/10/2019	100
11/10/2019	120
12/10/2019	130

So i need to get the difference between 12/10/2019 and 10/10/2019

130-100 = 30

120-100 = 20

From the beginning to the others day! im actually got this table using filters dates! Date has the filter so i can show me the report of that day!

[MFelix · Accepted solution]

Hi @panchinxd ,

You need to add a measure similar to this:

Value =
SUM ( 'Table'[Amount] )
    - CALCULATE (
        SUM ( 'Table'[Amount] );
        FILTER (
            ALLSELECTED ( 'Table'[Date] );
            'Table'[Date]
                = CALCULATE ( MIN ( 'Table'[Date] ); ALLSELECTED ( 'Table'[Date] ) )
        )
    )

Regards,

MFelix