measure between two dates (Modified date file)

[msarfaraz]

I am really struggling with finding a measure between two dates (Modified date file), see the below.

[v-chuncz-msft · Accepted solution]

@msarfaraz,

You may refer to the measure below.

Measure =
VAR m1 =
    MIN ( 'Tabe 1 Date'[Date modified] )
VAR m2 =
    MAX ( 'Tabe 1 Date'[Date modified] )
RETURN
    CALCULATE ( SUM ( 'Table 1'[Nights] ), 'Tabe 1 Date'[Date modified] = m2 )
        - CALCULATE ( SUM ( 'Table 1'[Nights] ), 'Tabe 1 Date'[Date modified] = m1 )

[msarfaraz]

Excellent ----- Its works perfect