Forum Discussion
Calculate values from different rows in the same column into a different column
Entry Date ID Value Total 1/1/2022 AA 1 8 1/2/2022 AB 2 9 1/3/2022 AC 3 0 1/4/2022 AD 4 4 1/5/2022 BA 5 8 1/6/2022 BC 6 6 1/7/2022 BD 7 7 1/8/2022 ...
I tried something like this but it didn't actually add the 2 values together. I'm hoping there is somone out there who likes a challenge and can help me out with this.
IF(FIRSTNONBLANK('External Data'[Dataset ID], 1)="AA",
CALCULATE(
CALCULATE(
SUM('TABLE'[Value]),
FILTER(
'TABLE',
CONTAINS('TABLE', 'TABLE'[ID], "AA")
),
FILTER(
'TABLE', 'TABLE'[Entry Date]=MAX('TABLE'[Entry Date])
)
) +
CALCULATE(
SUM('TABLE'[Value]),
FILTER(
'TABLE',
CONTAINS('TABLE', 'TABLE'[ID], "BD")
),
FILTER(
'TABLE', 'TABLE'[Entry Date]=MAX('TABLE'[Entry Date])
)
),
FILTER(
'TABLE', 'TABLE'[Entry Date]=MAX('TABLE'[Entry Date])
)
),
CALCULATE(
SUM('TABLE'[Value]),
FILTER(
'TABLE', 'TABLE'[Entry Date]=MAX('TABLE'[Entry Date])
)
)
)