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: sql.bi/828809?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

[@user-lm5wb8vi1x]

Finished watching

[@Dzidza1978]

Brilliant trick, especially when you need to speed things up, and dont know where to optimize more. Thx 😊

[@VictorHugo-bd3bf]

This is great; thank you, Alberto.

[@ed2921]

Welcome back Alberto!

[@NoShadowOfDoubt1]

Simply efficient!

[@mnowako]

Great video, very informative. Thank you!

[@learningnotes4952]

Hi SQLBI, I like your way to calculate the year month number ( year*12 + month ). I am wondering if there is similar way to calculate the year WEEK number? In my project, the week number in certain year is start by week 0 instead of week 1. Thank you!

[@SQLBI]

It depends, you should start from www.daxpatterns.com/week-related-calculations/ and also look at the weekly date table generated by Bravo bravo.bi where you can customize the template.