Protecting time intelligence expressions against non-consecutive range of days

ime intelligence functions are some of the most important functions in DAX. Being able to compare values between current period and the same period last year is a very common request and one that is a real challenge using native Excel and can easily achieved with DAX. A typical calculated field might look like: