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 when the accumulating value reaches/crosses a certain threshold.
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])
2 Replies
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. 👍
