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 doin...
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?
Anonymous
cycle time= count of analysis * 30
What's the DAX of reviewing time and lead time?
Lead Time is SUM( Cycle Time + Lead Time)
Review Time should just be Distinct count of analysis*Lead time value in this case 60.
so it should just be Lead Time = 1*60 for this case. I have list of a bunch of different lead times.
Anonymous
if i didn't misunderstand your explaination.
pls try
=distinctcount(analysis)* [testing cycle time]