Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Adding calculated values to table pre-filled with values

Hi, I want to create the below table where in i have some prefilled dtaa present. On this data I then want to add daily calculated values from other table using formulas please assist me how i can do...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

You need to take this differently for measure

You have to take

Initial End of Day +Cummlative Incoming - cumulative handled

 

Cumm Incoming= CALCULATE(SUM(Table[Incoming]),filter(date,date[date] <=max(Table[Date])))

Cumm Handled= CALCULATE(SUM(Table[Handled]),filter(date,date[date] <=max(Table[Date])))


Initial End of Day =
var _min = minx(table,Table[Date])
return
calculate(sum(Table[End of Day]) , filter(Date,Date[Date]=_min))

 

If initial end of the day is 0. you can only work with rest of the two