Excel BI Challenge Workout 199

LinkedIn Post by:
John Jairo V.

Hi to all!

:white_check_mark:`

One option could be:

=MAKEARRAY(ROWS(A2:B6),3,LAMBDA(r,c,LET(t,INDEX(A2:A6,r),s,SEQUENCE(1+INDEX(B2:B6,r)-t,t),d,FILTER(s,DAY(s)+MONTH(s)=–TEXT(s,“y”)),CHOOSE(c,ROWS(d),@d,MAX(d)))))

`

Blessings!