Forum Discussion

Aahil10's avatar
Aahil10
Frequent Visitor
5 years ago
Solved

Show Rolling Average on Daily Basis

Hello! I'm trying to show the rolling average of a dataset on a day to day basis. I am calulcating the average operating rate (%) for a given month.  I was able to calculate the Rolling Average for ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This measure should work on a card visual.  Ensure that there is a Calendar table with a relationship to the Date column of your Data Table.  To your slicer, drag Date from the Calendar Table and selected a Date.

    Measure1 = calculate([Assy OR],datesmtd(calendar[date]))

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

See the Table on page "Duplicate of Page 1".  Download the PBI file from here.

Hope this helps.

Aahil10's avatar
Aahil10
Frequent Visitor
5 years ago

Thanks!

I think this almost solves it, but now I'd like to Display the Monthly OR value for a given date on a card. If I try in your file, I get a blank.

 

So when the a Date e.g March 9 is selected, I can display Monthly OR as 96.82%

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    You are welcome.  Download the PBI file from here.

    Hope this helps.