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/20...
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]))
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]))
