Forum Discussion
Solved
Generate Series
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
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]))
3 Replies
yes, that is possible. What have you tried and where are you stuck?
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
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]))
