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.
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.
Solved! Go to 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
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
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |