Forum Discussion

Enigma's avatar
Enigma
Icon for Helper III rankHelper III
5 years ago
Solved

CALENDARAUTO not picking up date from a table

Hi,  I have a main table called IT_support_call_logs and multiple related tables. The main table has one row per IT support ticket created. Also, I have a date table built using CALENDARAUTO() and...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Enigma , better create with calendar

     

    Date  =

    var _min = eomonth(min(tblSherlockRaw[Ticket End Date])),0)

    var _max = eomonth(max(tblSherlockRaw[Ticket End Date])),12) 

    return

    calendar(_min, _max)

Enigma's avatar
Enigma
Icon for Helper III rankHelper III
5 years ago

Thanks amitchandak ,

Is there any reason CALENDARAUTO should not be used? is it not reliable?

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi Enigma ,

Please note this when using Calendarauto() function:

The date range is calculated as follows:

  • The earliest date in the model which is not in a calculated column or calculated table is taken as the MinDate.
  • The latest date in the model which is not in a calculated column or calculated table is taken as the MaxDate.
  • The date range returned is dates between the beginning of the fiscal year associated with MinDate and the end of the fiscal year associated with MaxDate.

 

Dates from calculated table would not be included in the calendar when using Calendarauto().

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Enigma's avatar
    Enigma
    Icon for Helper III rankHelper III
    5 years ago

    Thanks for this helpful information, v-yingjl I was not aware of this.