This seems simple enough, but I feel like I'm going in circles.
This data is stored in SQL Server.
I have a column that identifies the max date in the required date field. I have a calculation that is a projection for the next month, which I've labeled "NewCalc1". I need "NewCalc1" to be dynamic, and should be the max date plus one month, or "2021_11_01". I would do this for at least 12 months. "2021_12_01", "2022_01_01", etc.
Thanks!
Hi @Gary_Brock
I used Summarize to get the max date and then use Generate rows with some datetime functions to generate 12 months. Is this what you are looking for? Cheers!
Hi @Gary_Brock,
In addition to the solution provided by @christine_assaad, here is an example on how to use those generated dates to dynamically rename your forecast fields.