Forum Discussion
o59393
Post Prodigy
Post ProdigyCalendar Tables - Dynamic rolling 12M
Hi all I´d like to have a dynamic calendar which contains the last rolling 12 months. For example today is 2022-2-20. Therefore the calendar should go from February 2021 to January 2022. ...
Hi,
Try this Table formula
Calendar = CALENDAR(edate(EOMONTH(today(),-1)+1,-12),EOMONTH(today(),-1))
Ashish_Mathur
Super User
Super UserHi,
As i mentioned earlier, it is a bad idea to do that because a Calendar should always have a row for each data from start to finish. Furthermore, i do not even know how to do that in the DAX language. You should create the Calendar Table in the Query Editor instead and then filter that table to only show the first of each month. Someone else will help you with that.
o59393Post Prodigy
Post Prodigy
It's ok. Your code solved my problem, I will stick to your recommendation of full calendar instead.
Thank you!!
- Ashish_Mathur
You are welcome.