CalenderAuto

[Anonymous]

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?

[ryan_mayu · Accepted solution]

@Anonymous 

maybe  you can try to use calendar instead of calendarauto

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

[Anonymous]

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

[ryan_mayu]

you are welcome