Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi All,
I would like to create a calender like (24 months back from current date and 12 months future from current date). If its possible please let me know.
Thanks in advance
Solved! Go to Solution.
@harib Create like
calendar(date(year(today()),month(today())-24,day(today())),date(year(today()),month(today())+12,day(today())))
And from Month start to month-end
calendar(eomonth(date(year(today()),month(today())-25,day(today())),0)+1,eomonth(date(year(today()),month(today())+12,day(today())),0))
@harib Create like
calendar(date(year(today()),month(today())-24,day(today())),date(year(today()),month(today())+12,day(today())))
And from Month start to month-end
calendar(eomonth(date(year(today()),month(today())-25,day(today())),0)+1,eomonth(date(year(today()),month(today())+12,day(today())),0))