Find threshold date from accumulating value

[LarsPedersen]

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.

[amitchandak · Accepted solution]

@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]

You are a living Guru... 😇

Thanks for the solution, works exactly as I had hope. 👍