Generate Further Months in Same Row

[harshal98]

Want to Generate Further Months in the Same row while it takes other Column values with it where values are present.

INPUT

OUTPUT

[atcodedog05]

Hi @harshal98 

Your understanding is correct if we use generate rows it will replicate the row values. To avoid that months should be generated separately and later joined with values.

Hope this helps 🙂

[Qiu]

@harshal98 
We can fine tune the dateformat.

[AngelosPachis]

Hey @harshal98 ,

The TS filler tool would work best in this instance

You just need to point it to the Date field and define the date granularity (days, months, minutes) and it will generate the intermediate values.

Hope that helps

Cheers,

Angelos

[Jonathan-Sherman]

Love this solution @AngelosPachis, the TS Filler tool is so underrated and overlooked for this kind of thing! It is worth noting that anyone wanting to take this approach does need the predictive tools installed 😊

[atcodedog05]

Always something new to learn. Thank you for this approach @AngelosPachis 🙂