Daily Rolling Average by Month

[kc_]

Hello - I am trying to create the following report (highlighted in green) in Power BI:

In essence I am trying to calculate a rolling daily average for each working day completed per month.

Many thanks in advance!

[v-yangliu-msft]

Hi  @kc_ ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _count=
COUNTX(
    FILTER(ALL('Table'),'Table'[Working Day Number]<=MAX('Table'[Working Day Number])&&'Table'[Eo Month]=MAX('Table'[Eo Month])),[Value])
var _value=
SUMX(
    FILTER(ALL('Table'),'Table'[Working Day Number]<=MAX('Table'[Working Day Number])&&'Table'[Eo Month]=MAX('Table'[Eo Month])),[Value])
return
DIVIDE(
    _value,_count)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[kc_]

Thanks for the response, however, something is not quite working for me...the actual data set is a little more complex than I previosly screenshotted. I need to perform a count function of the Job Number field....trying to attach my PBIX file to no avail - hopefully the dropbox link works....

https://www.dropbox.com/scl/fi/lzjsf2wx7hwpl54gpbgq6/Rolling-Daily-Average.pbix?rlkey=z1o37qmvftbquv... 

Thanks