Date Table - Calendar function Not bring back Dates

[Anonymous]

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]))

[az38 · Accepted solution]

Hi @Anonymous 

try

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

or

Date = CALENDARAUTO()

[Anonymous]

Hi @az38 ,

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

[Anonymous]

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]

@Anonymous 

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

[Anonymous]

Hi @az38 ,

Yeh positive, but I deleted the old table I had created and started again and both solutions you gave me worked perfectly.

Thank you 😊