Forum Discussion
Need Help with Summing Values
I am trying to add up my cycle time and review time to give a column for lead time. the Cycle time is summing based on the count an Analysis (Tests) which is correct. however, the review time is doing the same, but I only need it to sum the review time for that row once, not for each count of analysis. Any help is greatly appreciated!
Anonymous
pls see the attachment below. Hope it's helpful.
still have a question. why the date for expected output is 2020/1/15 and 2020/1/16?
15 Replies
Anonymous
what's the expected output? could you pls also provide some sample data?
ryan_mayu Yes here is another example that I hope makes more sense:
on day 31 the count of Analysis (tests) is 2. the cycle time for one test is 30 so the value should be 60 which it is. however, the Review time only occurs once regardless of the amount of tests completed (Count of Analysis). the review time is 60 minutes. so the expected value is 60 however I am getting 120.
Let me know if the pictures are not enough and I will do my best to post the data. sorry this is my first time on this community forum! thanks for the help!
Here is the data baswed on the above explanation of expected outcome.
Here is a photo of the data in the transform data window
Anonymous
cycle time= count of analysis * 30
What's the DAX of reviewing time and lead time?