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. ...
Need Help
Tips and Tricks
Tutorial Requests
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