Forum Discussion
Date Table
Hi
I am trying to create a date table of previous month, current month and next 11 months
How can I do this in either M Language, or DAX
I want to then use this 13 month rolling table, as axis in my tables
I am stuck - any help appreciated
Cheers
J
2 Replies
You can leverage pulling today's date in as a variable and the EOMONTH function - offset backwards from the eomonth of today a couple of months and add 1 day to get a start value, then offset forwards 11 months to get your end value
This link has anM script to create a date dimension table.
https://insightsoutliers.com/2018/04/19/m-script-date-dimension/
