Forum Discussion
Solved
Find threshold date from accumulating value
Hi I've an accumulating total measure, which I use to line-plot the running/accumulating total over time (dates). Works fine! I need help to make a solution (measure) that can return the date wh...
LarsPedersen , Assume you have measure **bleep** Val on it cumulative on Date, then
Measure =
var _threshold = 10
return
Minx(filter( values(Date[Date]), [**bleep** Val]>=_threshold ), [Date])
LarsPedersen , Assume you have measure **bleep** Val on it cumulative on Date, then
Measure =
var _threshold = 10
return
Minx(filter( values(Date[Date]), [**bleep** Val]>=_threshold ), [Date])
You are a living Guru... 😇
Thanks for the solution, works exactly as I had hope. 👍