Optimizing time intelligence in DirectQuery

How to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions.
Article and download: https://sql.bi/828809?aff=yt

How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...