DAX calculated Column to return new Status until condition is met

[krkenzi]

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

[Ahmedx · Accepted solution]

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

[krkenzi]

works perfrectly