Use the first Weekday displayed when the Count <> 0 with conditions

[Tan_LC]

Hi,

In below table, any idea how to use Power Query to have the 1st Weekday displays when the Count <> 0 with the condition of Serial and Week of Year are the same. Else it should be no Weekday shows. 

Serial	Week of Year	Weekday	Count	Expected Result
1W8Y	32	Monday	0
1W8Y	32	Tuesday	0
1W8Y	32	Wednesday	0
1W8Y	32	Thursday	0
1W8Y	32	Friday	0
1W8Y	32	Saturday	0
1W8Y	32	Sunday	0
1W8Y	33	Monday	0
1W8Y	33	Tuesday	3	Tuesday
1W8Y	33	Wednesday	3	Tuesday
1W8Y	33	Thursday	3	Tuesday
1W8Y	33	Friday	3	Tuesday
1W8Y	33	Saturday	3	Tuesday
1W8Y	33	Sunday	0	Tuesday
22W2	32	Monday	0
22W2	32	Tuesday	0
22W2	32	Wednesday	0
22W2	32	Thursday	0
22W2	32	Friday	0
22W2	32	Saturday	0
22W2	32	Sunday	0
22W2	33	Monday	0
22W2	33	Tuesday	0
22W2	33	Wednesday	0
22W2	33	Thursday	3	Thursday
22W2	33	Friday	3	Thursday
22W2	33	Saturday	3	Thursday
22W2	33	Sunday	0	Thursday

Thanks.

LC

[Manoj_Nair · Accepted solution]

@Tan_LC 

Please check this out, let me know if this works. If this fix your problem, please tick this a solution and a thumps up.

https://github.com/msncps/PowerBI/blob/main/2023_08_09_Use%20the%20first%20Weekday%20displayed%20whe...