Forum Discussion

msarfaraz's avatar
msarfaraz
Frequent Visitor
7 years ago
Solved

measure between two dates (Modified date file)

I am really struggling with finding a measure between two dates (Modified date file), see the below.  
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    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 )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

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's avatar
msarfaraz
Frequent Visitor
7 years ago

Excellent ----- Its works perfect