Dates Table

[JJP1]

Hello,

I created a Dates Table with a column that captures all dates in an identified data set. I used the following formula to achieve this: 

DatesTable = CALENDAR(MIN('Daily WS Business Expertise'[Application_Received_Date]), MAX('Daily WS Business Expertise'[Application_Received_Date]))

I observed after some time that all items are no longer being filtered and displayed correctly in Power BI visuals. I found that I eventually had to add to the end of the formula above to get it to filter and display data in visuals. The first time I added '+10' to the formula and just recently, I had to add '+30', so it now looks like this:

DatesTable = CALENDAR(MIN('Daily WS Business Expertise'[Application_Received_Date]), MAX('Daily WS Business Expertise'[Application_Received_Date])+30)

Is there another measure I can use for this column, so that I do not need to keep adding # of days to the end of the measure every so often? Simply put, I am looking for a long-term/permanent solution that does not require regular maintenance of the measure. 

Any help is appreciated! Thanks!

[daircom · Accepted solution]

@JJP1 
Often simply creating a table using the below already works, as this formula looks at all the data in your data model.

Calendar_Table = CALENDARAUTO()

[JJP1]

This seems to work for now. It has happened where measures tend to work for some time and eventually they stop working. Hopefully this is the answer!