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!
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.
Brilliant trick, especially when you need to speed things up, and dont know where to optimize more. Thx 😊
Welcome back Alberto!
This is great; thank you, Alberto.
Great video, very informative. Thank you!
Simply efficient!
Finished watching
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!
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.