Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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]))
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]))
User | Count |
---|---|
88 | |
87 | |
73 | |
66 | |
57 |
User | Count |
---|---|
129 | |
102 | |
91 | |
83 | |
67 |