cancel
Showing results for
Did you mean:
Helper II

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

 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.

1 ACCEPTED SOLUTION
Community Support

Hi, @Surafel

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]
)
``````

Best Regards,
Community Support Team _ Janey

2 REPLIES 2
Community Support

Hi, @Surafel

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]
)
``````

Best Regards,
Community Support Team _ Janey

Super User

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

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

#### Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors