Date Table

[Anonymous]

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

[gooranga1]

This link has anM script to create a date dimension table.

https://insightsoutliers.com/2018/04/19/m-script-date-dimension/

[jthomson]

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