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...
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