Forum Discussion

PaulDenne's avatar
PaulDenne
Helper I
1 year ago
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...
Need Help
  • adudani's avatar
    adudani
    1 year ago

    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.

     

     

adudani's avatar
adudani
Memorable Member
1 year ago

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.

 

 

PaulDenne's avatar
PaulDenne
Helper I
1 year ago

just watched video and got it to work using rolling average

 

many thanks