How come this DAX Generate series as DATE does end as intended

[Anonymous]

New Table ->
DatesTest =

var currentDatint = day(today())

VAR CurrentMonthInt = MONTH ( TODAY () )

var currentYear = year(today())

var seriesDate = GENERATESERIES(Date(2022, 1, 1) , DATE(currentYear, CurrentMonthInt, currentDatint))
return seriesDate

when used it still returns the full year of end not up to the current date. 

[davehus]

Hi @Anonymous ,

I've tested your measure and it works fine. 

[Anonymous]

I see. How come the Date Hieracrchy part returns the full Date range and not the the range based on the values?

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

If you  enable 'Auto date/time option' in Options Pane of PowerBI, Power BI Desktop creates a hidden auto date/time table for each date column. The auto date/time table contains full calendar years encompassing all date values stored in the model date column.  Auto date/time tables are permanently hidden.

The date hierarchy you see is based on this auto date/time table.When an auto date/time table exists for a date column (and that column is visible), report authors won't find that column as a field in the Fields pane. Instead, they find an expandable object that has the name of the date column.

For more details, please refer to this document

Apply auto date/time in Power BI Desktop 

Best Regards,
Community Support Team _ Eason