How to determine a status based on others columns and grouping functions

[JuliCraps]

Hello gurus,

I'm face an issue to dermine a status of a row based on others columns and also linked to a calculatation of a global view

For example:

I need to determine the a status of SupplierValid (with value Yes/No)

based on following rules: 

• The Date DD/MM/YYYY column should be considered if exists in date range corresponding of Current date and last 3 months
• The ErrorYN column should be Yes (according to the date range)
• The number of raws respecting the previous rules should be greater or equal to 5

If all 3 rules are achived the status of SupplierValid should be set to Yes

Please find enclose an example

DocID	SupplierID	Date DD/MM/YYYY	ErrorYN	SupplierValid
1	SupA	01/01/2022	No	Yes
2	SupB	01/01/2022	No	No
3	SupC	01/01/2022	Yes	Yes
4	SupB	01/01/2022	No	No
5	SupB	01/02/2022	No	No
6	SupB	01/03/2022	No	No
7	SupB	01/04/2022	No	No
8	SupB	01/05/2022	No	No
9	SupB	01/06/2022	No	No
10	SupD	01/10/2022	No	No
11	SupA	01/10/2022	No	Yes
12	SupA	01/11/2022	No	Yes
13	SupC	01/11/2022	No	Yes
14	SupD	02/11/2022	No	No
15	SupA	02/11/2022	No	Yes
16	SupC	02/11/2022	No	Yes
17	SupD	03/11/2022	Yes	No
18	SupA	03/11/2022	No	Yes
19	SupC	03/11/2022	No	Yes
20	SupD	04/11/2022	No	No
21	SupA	04/11/2022	No	Yes
22	SupC	04/11/2022	No	Yes
23	SupE	05/11/2022	No	No
24	SupD	05/11/2022	No	No
25	SupE	06/11/2022	No	No
26	SupE	07/11/2022	No	No

Thanks lot for your help 🤗

[v-jialluo-msft]

^{Hi @JuliCraps ,}

^{Is the [SupplierValid] column the expected result you need?}

^{The results I filtered through several criteria didn't seem to get the expected results}

^{Please indicate further what you need}

^{Best Regards,}

^{Gallen Luo}