How woud I subtract 2 columns both caluculating volume from the same column but at different dates. The following code below works, however I can't get the volumes to filter on a specifc date. I.E I want to do the calculation
Volume(@Datepicker1) + Volume(@Datepicker2)
| Datepicker1 & Datepicker2 | Volume(@Datepicker1) | Volume(@Datepicker2) | Volume(@Datepicker1 = 09/01/23) - Volume(@Datepicker2 = 01/01/23 ) |
01/01/2023
01/01/2023
01/01/2023
01/01/2023
01/01/2023
01/01/2023
01/01/2023
01/01/2023
09/01/2023
09/01/2023
09/01/2023
09/01/2023
09/01/2023
09/01/2023
09/01/2023
09/01/2023
09/01/2023 | 3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 | 11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27 | 0
0
0
0
0
0
0
0
19 |
Datepicker_Test =
var Datepicker1 = SELECTEDVALUE(DateSprints[DatePicker1])
var Datepicker2 = SELECTEDVALUE(DateSprints[DatePicker2])
RETURN
CALCULATE(
SUM('SummaryFosAll'[Volume (M3)])-SUM('SummaryFosAll'[Volume (M3)]))
I tried
--------------------------------------------------------------------------------------------------
Datepicker_Test =
var Datepicker1 = SELECTEDVALUE(DateSprints[DatePicker1])
var Datepicker2 = SELECTEDVALUE(DateSprints[DatePicker2])
RETURN
CALCULATE(
SUM('SummaryFosAll'[Volume (M3)]), FILTER(ADDCOLUMNS(SummaryFosAll[Volume (M3)],DateSprints[DatePicker1]=Datepicker1))-SUM('SummaryFosAll'[Volume (M3)]))
----------------------------------------------------------------------------------------------------------
But I get an error
