Optimizing time intelligence in DirectQuery

How to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions.

---