Towards Data Science is a community-powered publication that showcases work in data science, machine learning and artificial intelligence. Every day newcomers, seasoned researchers and industry practitioners publish tutorials, research notes and real-world case studies that help the field move forward.

Towards Data Science

Calendar-based Time Intelligence in DAX simplifies some custom calculations but doesn't eliminate the need for custom logic entirely. The article demonstrates calculating rolling averages using standard Gregorian calendars, custom calendars (15 months with 31 days each), and weekly calendars. While standard calendars work seamlessly with DATESINPERIOD(), custom calendars without date columns require manual logic using ID ranges or row ranks. Performance optimization techniques include using TOPN() or RowRank columns, with execution times ranging from 100-500ms. Weekly calculations are now possible with calendar-based Time Intelligence, though semester intervals still require custom code.

Does Calendar-Based Time-Intelligence Change Custom Logic?