Forum Discussion

SQUILES's avatar
SQUILES
Helper I
7 years ago
Solved

sum range date

HI, everyone...

 

I have have a table with dates and values, i need to calculate (column) two totals.

 total1 = current value  + sum(13 days previous of this date)

 total2 = sum(next 14 days of the previous of that date)

Example:

 Total1 for 7/1/2019 = value of 7/1/2019 + range 6/30/2019 - 6/18/2019 (13 days)

 Total2 for 7/1/2019 = range from 6/17/2019 to 6/4/2019 (next 14 days)

 

Any help

 

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi SQUILES ,

     

    To create measures as below.

    total1 = 
VAR dat =
    DATE ( 2019, 07, 01 )
VAR last13 = dat - 13
RETURN
    CALCULATE (
        SUM ( 'Table'[vale] ),
        FILTER ( 'Table', 'Table'[date] >= last13 && 'Table'[date] <= dat )
    )

    total 2 = 
VAR d =
    DATE ( 2019, 07, 01 )
VAR a = d - 14
VAR c = a - 13
RETURN
    CALCULATE (
        SUM ( 'Table'[vale] ),
        FILTER ( 'Table', 'Table'[date] <= a && 'Table'[date] >= c )
    )

     

3 Replies