cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Imthedan
Helper I
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. 

 

Thank you for your help!

Imthedan_0-1623953567765.png

 

2 REPLIES 2
amitchandak
Super User IV
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])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

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

R2 (Green) 768 x 460px.png

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.