Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Datetable

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

 

Need Help
Show and Tell
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    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.

     

3 Replies

  • rohit_singh's avatar
    rohit_singh
    Solution Sage
    4 years ago

    HI Anonymous ,

    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! ğŸ˜Š

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, Anonymous 

     

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks you the seems to work.