Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

CalenderAuto

Hi,

I have created one table for the calenderauto function to get the dates in my data source so that I can create a unique table but the problem is that it is showing months from Jan-22 to Dec-23 in columns but I required only those months for which I have the data in my source like I have a date range from sep-22 to present so I need all the dates in that from sep-22 to present and should go on as dates are adding.

Is any one know how to do it?

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    Anonymous 

    maybe  you can try to use calendar instead of calendarauto

    calendar(min(table[date]),max(table[date])

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    3 years ago

    Anonymous 

    maybe  you can try to use calendar instead of calendarauto

    calendar(min(table[date]),max(table[date])

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you for the solution I just tried this and it worked fine.