Show a date where the forecasted remaining capacity starts to fall below 20%

[Anonymous]

Date	Remaining Capacity %
24/01/2021	57
25/01/2021	65
26/01/2022	75
27/01/2022	24
28/01/2022	54
29/01/2022	87
30/01/2022	12
31/01/2022	8
1/02/2022	6
2/02/2022	4
3/02/2022	2
4/02/2022	-2
5/02/2022	-7
6/02/2022	-10
7/02/2022	-20
8/02/2022	-60

I want to indicate the date when the remaning predicted capacity percent starts to fall below 20%, as shown in the graphic above.
Please, if anyone knows how I can accomplish this with DAX, please let me know.

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

According to your description, I think you can create a measure to show the result.

Like this:

Measure = 
MINX (
    FILTER (
        SUMMARIZE ( 'Table', [Date], [Remaining Capacity %] ),
        [Remaining Capacity %] < 20
    ),
    [Date]
)

If [Remaining Capacity %] is a measure.

Try:

Measure2 = 
MINX (
    FILTER (
        SUMMARIZE ( 'Table', [Date], "a", [Remaining Capacity %measure] ),
        [a] < 20
    ),
    [Date]
)

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[lbendlin]

No DAX required, all you need is conditional formatting. See attached.