Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date Table - Calendar function Not bring back Dates

Hi,
 
I'm trying to create a Date table and the below statement doesn't show the dates I need it to show below, can someone please assist with spotting what I've written incorrectly below.
 
Date = CALENDAR(FIRSTDATE('Order Details'[ReceievedDate]),LASTDATE('Order Details'[ReceievedDate]))
Need Help
Show and Tell
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try

    Date = CALENDAR(MIN('Order Details'[ReceievedDate]),MAX('Order Details'[ReceievedDate]))

    or

    Date = CALENDARAUTO()

5 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Anonymous 

    try

    Date = CALENDAR(MIN('Order Details'[ReceievedDate]),MAX('Order Details'[ReceievedDate]))

    or

    Date = CALENDARAUTO()
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi az38 ,

       

      Thanks for getting back to me, but neither shows the dates in my Date column.

       

      I've double checked that the field I'm referencing for dates in the below is a date field which it is so completly stumped as to why it would not show the dates because the syntax is correct.

       

      Date = CALENDAR(MIN('Order Details'[ReceievedDate]),MAX('Order Details'[ReceievedDate]))

      • az38's avatar
        az38
        Community Champion
        6 years ago

        Anonymous 

        are you sure your 'Order Details'[ReceievedDate] field has a Date type?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi az38 ,

       

      I just deleted the existing Date table I had and created a new one and I can now see dates using CALENDARAUTO.