Forum Discussion

waleed111's avatar
waleed111
Helper V
6 years ago

calendar cannot be blank

when i use this formula: Date = CALENDAR('List View'[start date], 'List View'[end date]) it show me this error: The start date or end date in Calendar function can not be Blank value.
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi waleed111 ,

Calendar() returns a table. As Fowmy , amitchandak said , use MIN() , MAX() to specify the date like this:

 

Date Table =
CALENDAR ( MIN ( 'List View'[Start Date] ), MAX ( 'List View'[End Date] ) )

 

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

 

Best Regards,
Eyelyn Qin