This pattern shows how to compute time-related calculations like year-to-date, same period last year, and percentage growth using a custom calendar. This pattern does not rely on DAX built-in time intelligence functions and can be used in those cases where a calendar does not satisfy the requirements for standard DAX time-intelligence functions, like when a fiscal year starts on a month other than January, April, July, or October.
To make sure your requirements need a custom time-related calculations pattern and cannot be implemented using another simpler pattern, check the Time-related calculations introduction to figure out what is the right pattern for your scenario.
mindblowing formulas! loved it and learned a lot ! molto grazie Marco
carlos barboza(Mar 8, 2021)
mindblowing formulas! loved it and learned a lot ! molto grazie Marco
carlos barboza(Mar 8, 2021)
mindblowing formulas! loved it and learned a lot ! molto grazie Marco !!!!
Mark Walter(Aug 18, 2020)
Excellent and compressive series covering different custom time scenarios. I always learn something new from Marco and Alberto that applies directly to my job.