Forum Discussion
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.
waleed111
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 🙂
after 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.