Generate Series

[ArunKumar3333]

Is it possbile to generate a series of dates dynamically like this based on todays date , thats is start of each month , 12 months from todays date 

1/3/2024
1/4/2024
1/5/2024
1/6/2024
1/7/2024
1/8/2024
1/9/2024
1/11/2024
1/12/2024
1/1/2025
1/2/2025
1/3/2025

[lbendlin]

yes, that is possible. What have you tried and where are you stuck?

[ArunKumar3333]

i used generate series , and gave start date and end date dynamically using today date , but not able to give the difference , then i m not getting the 1 of every month , can you please share the formula 

[lbendlin · Accepted solution]

Table = GENERATE(GENERATESERIES(0,12),SELECTCOLUMNS({DATE(YEAR(EDATE(TODAY(),[Value])),MONTH(EDATE(TODAY(),[Value])),1)},"Date",[Value]))

You can also use EOMONTH

Table 2 = GENERATE(GENERATESERIES(0,12),SELECTCOLUMNS({EOMONTH(TODAY(),[Value]-1)+1},"Date",[Value]))