Forum Discussion
Tan_LC
Helper II
Helper IIUse the first Weekday displayed when the Count <> 0 with conditions
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
Please check this out, let me know if this works. If this fix your problem, please tick this a solution and a thumps up.
1 Reply
- Manoj_Nair
Solution Supplier
Please check this out, let me know if this works. If this fix your problem, please tick this a solution and a thumps up.