Forum Discussion
calendar cannot be blank
when i use this formula:
28 Replies
waleed111
Try it this way, Hope you are adding a new calendar table based on List View TableDate = 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.
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 🙂
waleed111 , if you are taking from other tables it needs to min /max
Date = CALENDAR(Min('List View'[start date]), max('List View'[end date]))
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Appreciate your Kudos.now it show me this error
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
