3MRA calculation not working?

[Anonymous]

A rolling 3-month average calculated column DAX snippet I've used sucessfully many times in the past is doing literally nothing in a new project I am developing. There are no apparent errors (unless I am looking in the wrong place), it just doesn't do anything.

Would a circular ref error cause this? If so, how do I figure out exactly what it doesn't like so I can take steps to a resolution?

[Anonymous]

I do have a date dimension in the project, and there is a relationship between it and the date column used at the row levels here. Like I said, I've used it (sucessfully) at least half a dozen times before, and this is the first time it doesn;t work. Only difference is this project is considerably more complex, which has me wondering about a circular ref error. I don't know how to find it though, and do wish PBI had some kind of error checking like Excel or step-through like VBA.

[parry2k]

@Anonymous I don't expect it to work, because of the row-level filter context. First and foremost, you should add a date dimension to your model and perform all-time intelligence calculations using this new date dimension. There are many posts on how to add one and I have on it here, use that dimension, and then do the calculation.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡