Forum Discussion
waleed111
Helper V
Helper Vcalendar 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.
Fowmy
Super User
Super Userwaleed111
Try it this way, Hope you are adding a new calendar table based on List View Table
Date = CALENDAR(MIN('List View'[start date]),MAX( 'List View'[end date]))
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
waleed111Helper V
Helper Vafter i use your solution it show me this error: Column 'start date' in table 'List View' cannot be found or may not be used in this expression.
- Fowmy
waleed111
As per your code, you are trying to create a calendar table by supplying the Start Date and End Date from another table. That particular table should contain valid dates in both the columns.
Do provide an explanation of what you are trying to achieve________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂