Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 EXCLUDES zero. My initial Equation Looks like this:
It looks like it's taking the blank days and including them in the average.
I also tried using the "New Quick Measure" feature but every time I did it would look like this:
Solved! Go to Solution.
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 @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.
Make it blank and try
VAR __LAST_DATE = LASTDATE('(5-1) Shift Turnover Data'[Date])
RETURN
AVERAGEX(
DATESBETWEEN(
'(5-1) Shift Turnover Data'[Date],
DATEADD(__LAST_DATE, -1, DAY),
DATEADD(__LAST_DATE, 5, DAY)
),
if(CALCULATE(SUM('(5-1) Shift Turnover Data'[(5.1) 8 H.r Output]))=0, blank(),CALCULATE(SUM('(5-1) Shift Turnover Data'[(5.1) 8 H.r Output])))
)
)
In case date do not include time do not use ,date -> Shift Turnover Data'[Date].[Date] only use Shift Turnover Data'[Date]
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |