List of dates

[richard_wylde]

Hello,
 
I need to create a column containing a  List of Dates   within a year of the current date. (to allow users to choose a date)
 
I've used the TODAY() function  :-

= CALENDAR ( DATEADD(TODAY(),-1,year), DATEADD(TODAY(),+1,year)

also an existing date column :-

= CALENDAR (DATEADD(INSTALMENTS[Renewal Date] ,-1,year) ,DATEADD(INSTALMENTS[Renewal Date] ,+1,year) )

...but still no joy. Could you show me what I'm doing wrong please

[richard_wylde]

Hi @Tahreem24 ,  sorry I don't understand - could you provide an example please ?

thanks.

[VijayP]

@richard_wylde 

You can see the screen Shot to achieve this

[richard_wylde]

Thanks @VijayP - do you know what I could use for the dates ? - I've tried TODAY() however this doesn't work :-

Table = CALENDAR (DATEADD(TODAY() ,-1,year) ,DATEADD(TODAY() ,+1,year) )

[VijayP · Accepted solution]

@richard_wylde 

Calendar(min(Date Column in your data),max(date column in your data))

[richard_wylde]

Thanks @VijayP , that's great !

[Tahreem24]

YOu need to create a Table not the column. CALENDAR DAX returns table of dates.