AnonymousNot applicable8 years agoSolvedhow to Create calendarHow to create calendar in BI which show us Lease Start and End DateAnonymous7 years agoAnonymous,Please create the calendar table using DAX below and check if you get expected result. Date = CALENDAR(MIN(Table1[Start Date]),MAX(Table1[End Date])) Regards,LydiaAnonymous to Anonymous7 years agoAnonymous,Glad to hear the issue is solved, you can accept my reply as answer to close this thread.Regards,Lydia
Anonymous7 years agoAnonymous,Please create the calendar table using DAX below and check if you get expected result. Date = CALENDAR(MIN(Table1[Start Date]),MAX(Table1[End Date])) Regards,LydiaAnonymous to Anonymous7 years agoAnonymous,Glad to hear the issue is solved, you can accept my reply as answer to close this thread.Regards,Lydia
Anonymous7 years agoAnonymous,Please create the calendar table using DAX below and check if you get expected result. Date = CALENDAR(MIN(Table1[Start Date]),MAX(Table1[End Date])) Regards,Lydia
Anonymous to Anonymous7 years agoAnonymous,Glad to hear the issue is solved, you can accept my reply as answer to close this thread.Regards,Lydia
4 RepliesReplies sorted by Most LikedAnonymousNot applicable7 years agoAnonymous,Please create the calendar table using DAX below and check if you get expected result. Date = CALENDAR(MIN(Table1[Start Date]),MAX(Table1[End Date])) Regards,LydiaAnonymousNot applicable to Anonymous7 years agoThanks, got resolved AnonymousNot applicable to Anonymous7 years agoAnonymous,Glad to hear the issue is solved, you can accept my reply as answer to close this thread.Regards,LydiaShow More
AnonymousNot applicable7 years agoAnonymous,Please create the calendar table using DAX below and check if you get expected result. Date = CALENDAR(MIN(Table1[Start Date]),MAX(Table1[End Date])) Regards,Lydia
AnonymousNot applicable to Anonymous7 years agoAnonymous,Glad to hear the issue is solved, you can accept my reply as answer to close this thread.Regards,Lydia
Related contentCreate a Calendar Year VisualCalendar Slicer with Different Business CalendarsCustom calendarTweaking Financial CalendarCreate weekly Calendar table
