Forum Discussion
Solved
17 week average
have got a date set of daily timesheets have done a measure to summarise weekly hours but can't get the average right to exclude zero weeks in the average even ones with all 17 weeks populated av...
hi PaulDenne ,
Within the "Filter" in your measure, maybe add " && CurrentWeek <> "Week 0" //whatever the week number not required is.
Also, an alternative method to calculate a dynamic moving average : How to Calculate Moving Averages in Power BI - The Ultimate Guide
P.S. you could upload a google/one drive link with the pbix file if this is not resolved.
