Forum Discussion

kc_'s avatar
kc_
Icon for Helper I rankHelper I
2 years ago

Daily Rolling Average by Month

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!

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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