Designer - create every quarter for every investment record

Question

Hi all,

I am struggling with a problem. I want every quarter to be represented from the first investment date until today (2022 Q3). This is the data I have:

Company nameDateRoundShare priceValuationxQ4 2021111 000 000xQ1 2022223 000 000yQ1 2022141 000 000

The desired output:

Company nameDateRoundShare priceValuationxQ4 2021111 000 000xQ1 2022223 000 000xQ2 2022223 000 000xQ3 2022223 000 000yQ1 2022141 000 000yQ2 2022141 000 000yQ3 2022141 000 000

DataNath · Accepted Answer

How does this look @Pirasant? Can't think of any massive factors that may trip this up but do let us know if there's any issues when applying this to a wider data set.

Pirasant · Accepted Answer

Thank you very much! This worked like a charm