Solved: Re: measure between two dates (Modified date file)

msarfaraz · ‎11-20-2018

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

v-chuncz-msft · ‎11-20-2018

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 )

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎11-20-2018

@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 )

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.