Great! – glad to hear that worked well for you. A couple things I forgot to mention - in the solution I sent you, I upgraded your date table to the Extended Date Table so you could play around with it. Also, below is a cheat sheet I put together listing the fields and the formats for each one. Finally, if you’re interested in really leveraging the power of the new date table for other time intelligence functions, @Melissa and I put together a multipart video series on that topic.
Video #2 and #6 (offsets) are the most essential ones IMO if you don’t have time to go through the whole series.
- Brian
