Forum Discussion
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 t...
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 ) )
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 )
)
