Datetable

[Mike89]

Hello everyone,

It seems my date table is not working the correct way.

I have created a simple new tabel with = Calendarauto().

Added the month and selected mark as datetable. 

Now I dont see the calendar icon near date.

Also when i create a filter with months its not in the right order.

In ideas how this could have happend? I have checked the formats

[v-zhangti · Accepted solution]

Hi, @Mike89 

You can try a different way of creating a new date table.

Table:

Date = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mike89]

Thanks you the seems to work.

[rohit_singh]

HI @Mike89 ,

Try right-clicking on your date table --> "Mark as date table"

Select and validate the date column

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊