Forum Discussion

JJP1's avatar
JJP1
Regular Visitor
2 years ago
Solved

Dates Table

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!
Need Help
Show and Tell
Tips and Tricks
  • daircom's avatar
    daircom
    2 years ago

    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()

2 Replies

  • daircom's avatar
    daircom
    Resolver II
    2 years ago

    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's avatar
      JJP1
      Regular Visitor
      2 years ago

      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!