Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Computing rolling average in DAX

SQLBI
120K subscribers
79K views 4 years ago
Computing the rolling 12-months average in DAX looks simple, but it hides some level of complexity. This article explains how to write the best formula and how to avoid common pitfalls using time intelligence functions. Article and download: https://sql.bi/15161?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... ...more
...more
Computing rolling average in DAX
1.5KLikes
79,442Views
2021Apr 6
Computing the rolling 12-months average in DAX looks simple, but it hides some level of complexity. This article explains how to write the best formula and how to avoid common pitfalls using time intelligence functions. Article and download: https://sql.bi/15161?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...

Follow along using the transcript.

SQLBI

120K subscribers