Want to Generate Further Months in the Same row while it takes other Column values with it where values are present.
INPUT
OUTPUT
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 🙂
@harshal98
We can fine tune the dateformat.
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
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 😊
Always something new to learn. Thank you for this approach @AngelosPachis 🙂