DAX Create a Date Table

[pfarahani]

Hi All,

I have the following DAX Code, that works to produce a Date table, which has the Start date of the Month, and the End date of the Month. I am trying to use my two Variables, in order to put ranges on the dates it produces. Instead of hard coding the date (2017). Any ideas of how I can incorporate the Variables? Thanks

[Greg_Deckler · Accepted solution]

@pfarahani Seems like you could replace 2017 with YEAR(Min_EOM)?