Forum Discussion

KBD's avatar
KBD
Icon for Helper III rankHelper III
1 year ago

calc a rolling rate

Hello:    Returning to the folks who know a little bit more that I do. I am struggling to calc a running rate.  I have to be able to calc this rate over dynaminc (user selected via a slicer ) per...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Please 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

KBD's avatar
KBD
Icon for Helper III rankHelper III
1 year ago

As Ibendlin suggested  have created a mock up which highlights the issue.  It was a good suggestion. 

 

Power BI viz:  https://drive.google.com/file/d/17dcoCnwZWXSEjgVcTkaWVqWKRXPEUqr-/view?usp=drive_link

Supporting Data:  https://docs.google.com/spreadsheets/d/1ZS01L-gbgo4Yx-6axvqEk7WZjlyMsy-j/edit?usp=drive_link&ouid=111344600491685564806&rtpof=true&sd=true

Worksheet / Scap:  https://drive.google.com/file/d/17dcoCnwZWXSEjgVcTkaWVqWKRXPEUqr-/view?usp=drive_link

 

Hope these links work