Calculate the rolling average for 12 months in #DAX and a nice IF optimizationhttp://sqlblog.com/blogs/marco_russo/archive/2014/07/03/calculate-the-rolling-average-for-12-months-in-dax-and-a-nice-if-optimization.aspxAlberto published the Rolling 12 Months Average in DAX article on SQLBI a few days ago, which includes interesting consideration about how to avoid the pitfall of touching the boundaries of the Date table, which could result in a calculation error. MoreenCommunityServer 2.1 SP2 (Build: 61129.1)re: Calculate the rolling average for 12 months in #DAX and a nice IF optimizationhttp://sqlblog.com/blogs/marco_russo/archive/2014/07/03/calculate-the-rolling-average-for-12-months-in-dax-and-a-nice-if-optimization.aspx#54433Mon, 07 Jul 2014 10:19:08 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:54433sled<p>'Am probably stupid, but i don't understand the formula and i don't see where is the Rolling average for 12 months compute ? Could you precise a little more with a specific example or something like that ? Thanks Marco.</p>
<p>A stupid guy :)</p>
re: Calculate the rolling average for 12 months in #DAX and a nice IF optimizationhttp://sqlblog.com/blogs/marco_russo/archive/2014/07/03/calculate-the-rolling-average-for-12-months-in-dax-and-a-nice-if-optimization.aspx#54436Mon, 07 Jul 2014 13:32:29 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:54436Marco Russo (SQLBI)<p>It's in the <expression>, described in the article I was commenting (follow the link in the post) :-)</p>