Time intelligence in Microsoft Power BI

Every Microsoft Power BI model has dates and the need for calculation over dates to aggregate and compare data, like year-to-date, same period last year, moving average, and so on. Quick measures and DAX functions can help, but how do you manage holidays, working days, and weeks based on fiscal calendars and any non-standard calculation?

---