Comments
-
@MarkSnodgrass , you are THE man! I think I would have got there eventually using your "Filling in date gaps" video, but this latest one shows a considerably more efficient method than where I was headed. Thanks again!
-
@MarkSnodgrass , I knew you'd come through! I was just combing through your Youtube videos trying to see if you had mentioned something like this previously. For some reason, I never considered using a window function like LAG for a non numerical value. All of that said, I am still a bit lost with this point: "Use the…
-
Thank you for your suggestion. I have updated my original question, which admittedly, was not detailed enough. 😀