Forum Discussion
Solved
Rolling Average Excluding Zero
Hello, I have looked through this forum quite a bit and i'm seeing solutions very similar to what i'm trying to figure out, but not exactly what I need. I'm looking for a Rolling Average that...
Hi chrishnrh57,
It is hard to find out your table structure and test from your snapshot. Can you please share some dummy data with the same table structure?
How to Get Your Question Answered Quickly
In addition, I'd like to suggest you use date function to manually define filter range instead of using time intelligence functions. (they do not support custom)
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
Hi,
I don't think any software will force a value in a blank cell to compute an average. Simplify your request by sharing a simple Excel file and show the expected result there. Share the link from where i can download your PBI file.