Forum Discussion
Helper IIIcalc a rolling rate
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Helper IIIHere I am trying to calc a rate that measures soccer player efficiency. I simple measure to compare players.
like this ( goals + ( assists * .5) ) *60 / minutes played. This mirrors the formula in my real data set.
Lets go through testGoalAssist the dashboard.
Page 1: contains monthly measures taking into account the slicers. All good here
Rolling I: created measures the accumulate over the months
As currently set, accumulate the goals , assists and minutes played for Mar 2022 - June 2022.
This works. Viz in the lower left contains the correct results. All good here.
Next I want to roll the efficiency measure over the months like this:
( sum goals over the months + ( sum assists over the months * .5) ) *60
divided by
sum minutes played over the months
Rolling II: looking at the viz Top center
effectiveRateOverPeriods A : returns the expected results .
effectiveRateOverPeriods: is wrong. Not returning what I expect.
do not understand what it is doing. Not the returning my formula above.
Refering to the spreadsheet: goals_assists_mar_june at the top you can find
a spreadsheet showing what I expect
There are links to to G Drive below.
I cannot explain what is going on here. It is beyod me.
Many thanks for your assistance.
KD