Forum Discussion
DAX for calculating a running average over defined days, including filtering out dates
- 4 years ago
Hi dsalony ,
I can't reproduce your issue when creating a simple model like the attchment. Could you create one meet your scenario for test? Please don't contain any sensitive information.
Reference:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hey. thanks so much for responding... unlike in the simple model you attached, I didn't have the data/value that was being averaged in the same table as the one being used for the date field; I was using a separate table for my dates (model is much more complex, with mulitple table relying on one date table that I use in a single direction filtering context; in my DAX formula, I moved all my references to the table that had the value being averaged, and it worked. thanks for your help man!