Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Conditional Summing based on the last time one value occured

Dear All,   I am trying to sum one of the item in a specific column after another condition Occured. For example, below is my sample data set   I would like to calculate all the process ti...
Need Help
Mohammad_Refaei's avatar
Mohammad_Refaei
Icon for Solution Specialist rankSolution Specialist
5 years ago

Try this:

Time =
CALCULATE (
    SUMX ( DATA, DATA[Duration (Hour)] ),
    DATA[Condition] = "Process Time",
    FILTER ( ALL ( DATA ), DATA[Index] <= [Maximum index] )
)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Refaei,

 

Thank You for your answer.

Now it give some value but

It return value of sum of all process time in the table. 

 

i.e. from index number 1 to last index number if its process time it is added.

 

Do you have any other idea?


Regards,

Handy Pratama