Forum Discussion

csrapp96's avatar
csrapp96
Icon for Helper I rankHelper I
4 years ago
Solved

Rolling Average Measure (with Parameter) - Trading Days Only

Hi all!    First off, thank you in advance for your help. For something that seems so easy, this one defintely threw me for a whirlwind because of PBI's time intelligence.   I have data I need to...
Need Help
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

csrapp96's avatar
csrapp96
Icon for Helper I rankHelper I
4 years ago

hi again Ashish_Mathur !! 

one follow-up question for your great answer - how would I display just the period where the true rolling average begins? For example, If I had a 5 day rolling average, the first 5 days would NOT display in the visual and it would start at day 6 once there is a rolling average. Same if it was a 30 day rolling average in the parameter, it would start at day 31 of data on my visual.

THANK YOU!

 

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

Hi,

If you have a 5 day rolling average, then the SMA should start apearing from Day 5 itself (not from Day 6).  You may download my PBI file from here.

Hope this helps.

 

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

    You are welcome.  Thank you for your kind words.

  • csrapp96's avatar
    csrapp96
    Icon for Helper I rankHelper I
    4 years ago

    Ashish_Mathur wow, you are truly incredible - I aspire to code like you someday! Wish I could give it 10 thumbs up