Forum Discussion
Cumulative sum when target achieved, get the date
Is your Target always 100 or is it variable?
Essentially I would create a measure to apply a filter show rows where t_cumu is higher than the target and then grab the MIN(Date).
I've hardcoded the target but this could be made dynamic
Target Hit Date = CALCULATE( MIN(MyTable[Date]), FILTER( MyTable, MyTable[t_cumu] > 100 ) )
Hi Phil_Seamark !
Yes the Target is at the moment only 100 so no need to use any variable here.
I tried the calculation that you provided, but for some reason it returns a (blank) value for me. Any idea what could cause this?
Thank you for your help already :) I try, if I can solve it somehow on my own also ..
Cheers,
Niko
- Phil_Seamark9 years ago
Microsoft Employee
What is the name of your table?
- nisuomi9 years ago
Resolver I
Phil_Seamark it is named like DataTable.
I replaced MyTable with that but did not work..
- Phil_Seamark9 years ago
Microsoft Employee
Are you creating it as a calculated measure?
And did you replace all three occurrences?