Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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 , 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. 👍
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |