Forum Discussion
Solved
DAX calculated Column to return new Status until condition is met
Hi all,
I am trying to get calculated column to show me Final Status(Outcome) of each item. If [Status] change to DOWN outcome should stay DOWN until 3 consecutive dates in [Impact] column are 'LN' are acheived. Once acheived Outcome should change back to UP and so on.
| Date | Status | Impact | Outcome |
| 1-Sep | LN | UP | |
| 2-Sep | UP | ||
| 3-Sep | LN | UP | |
| 4-Sep | LN | UP | |
| 5-Sep | LN | UP | |
| 6-Sep | DOWN | DOWN | |
| 7-Sep | LN | DOWN | |
| 8-Sep | LN | DOWN | |
| 9-Sep | LN | UP | |
| 10-Sep | UP | ||
| 11-Sep | LN | UP | |
| 12-Sep | LN | UP | |
| 13-Sep | LN | UP | |
| 14-Sep | LN | UP | |
| 15-Sep | LN | UP | |
| 16-Sep | DOWN | DOWN | |
| 17-Sep | LN | DOWN | |
| 18-Sep | DOWN | ||
| 19-Sep | LN | DOWN | |
| 20-Sep | LN | DOWN | |
| 21-Sep | DOWN | ||
| 22-Sep | LN | DOWN | |
| 23-Sep | LN | DOWN | |
| 24-Sep | LN | UP | |
| 25-Sep | LN | UP | |
| 26-Sep | LN | UP | |
| 27-Sep | LN | UP | |
| 28-Sep | LN | UP | |
| 29-Sep | LN | UP | |
| 30-Sep | LN | UP |
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RikVE_wiBAbmIO769?e=Sgyh9x
2 Replies
- Ahmedx
Super User
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RikVE_wiBAbmIO769?e=Sgyh9x
works perfrectly
