New column that checks if date is in multiple dynamic date ranges

Hi bernate ,

Really happy to help you solve this. Here's my solution below.

1.Go through a few steps to get the next date.(reference:Value from previous row )

2.In Date Table, reference the start date field and the next start date field from Product Archive table.

3.Expand it.

4.Create below custom for filtering. Filter out 1.

And here's your final column you want.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.