Recursive CTE BAQ - Help Needed

[dgreenEA (Dylan Green)]

I have found this article from @Banderson that seems to do the same thing I’m trying to do for the first union statement:

CTE with multiple unions not merging all columns

right, what I suggested will do that. What’s not working when you try it? In your example if it’s only returning jan and may (the ones with 2 values) it’s because you have an inner join. Make it an outer join. [image] edit and I see what you mean about the dates., Use a case statement in a calculated field. This is a really bad example, but basically this is the structure. If your first date is null, use the second date, if the second date is null use the third date, else use the first date…

Hopefully following this will allow me to build the union statement I want afterward.