cancel
Showing results for
Did you mean:
Helper I

Getting a rolling average based on total vs. total days?

Hello,

I am trying to get a simple average that is based on how many days have been ran in my time period. I'd want to get 177 divided by 4 (since there have been four Fridays). Since five total Wednesday's have been ran, I'd want to get the total of Wednesday divided by 5.

I need this to be a rolling average as well, so it updates based on the calendar updating.

2 REPLIES 2
Super User IV

@Imthedan , Isincope should help

assume you have measure then try like

Sub Total= calculate(averagex(values(Date[Date]),[measure]) ,filter(allselected(Date), Date[Day Name] = max(Date[Day Name])))

FInal measure = if(isinscope(Date[Day Name]) && not(isinscope(Date[Date])), [Sub Total], [Measure])

Proud to be a Super User!

Helper I

I put in the code and got an error saying the filter function passed too few arguments.

Here is the code I used:

Sub Total = CALCULATE(AVERAGEX(VALUES(LU_Calendar[Date]),[Total_Test]),FILTER(ALLSELECTED(LU_Calendar[Date],LU_Calendar[Day Name] = MAX(LU_Calendar[Day Name]))))

Do you see the issue?

Thank you!

Announcements

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors