Forum Discussion

bryanrendra's avatar
bryanrendra
Icon for Helper II rankHelper II
6 years ago
Solved

Cumulative total with multiple item and time

 I have been googling and still cant find the best way to generate updated price value. I am trying to find updated price value that coming from original price + running total incremental price in gi...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

bryanrendra , Try one of the two

 

DropPrice = 'Table'[Original Price]+CALCULATE(SUM('table'[IncrementalPrice]),
filter(
ALLSELECTED('table'),'table'[Date]<= max('table'[Date]) && 'table'[item] max(='table'[Date])))



DropPrice = 'Table'[Original Price]+CALCULATE(SUM('table'[IncrementalPrice]),
filter(
ALLSELECTED('table'),'table'[Date]<= max('table'[Date]) ))

bryanrendra's avatar
bryanrendra
Icon for Helper II rankHelper II
6 years ago

It works!, my problem was the original price and incremental price were at two different table with their own dates column. Now I have finally manage to create  dimension date and the formula works. Thank you!