Forum Discussion

ashishrj's avatar
ashishrj
Icon for Power Participant rankPower Participant
9 years ago

Calculating Running Average for the Current Financial Year

Hello folks, Need your help for calculating the running average for the current financial year. Below is the scenario: I have 2 tables. 1] Date table  2] Branch Details table  I have a column with...
Need Help
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

ashishrj

 

This is a Measure I use to show me the average across the months selected (which is the line in the chart)

 

So whatever Measure you are using to plot the individual columns use it in this formula

 

to get the line which represents the average across allselected months (hope this makes sense)

 

MEASURE Avg/Mo =
DIVIDE (
    CALCULATE ( [MEASURE], ALLSELECTED ( 'Calendar' ) ),
    CALCULATE (
        DISTINCTCOUNT ( 'Calendar'[Year-Month] ),
        ALLSELECTED ( 'Calendar' )
    ),
    0
)

This is the result

 

So regardless if I display all data ( and have to scroll on a very long chart) or narrow down with the Slicers

the line will be the average across only the selected number of months

 

At least thats how I understood your question

 

 

 

 

Hope this helps!

Good Luck! :smileyhappy:

 

  • ashishrj's avatar
    ashishrj
    Icon for Power Participant rankPower Participant
    9 years ago

    Thanks Sean for your reply but ultimately that does not work around for me. Let me know if there is any other approach for the same.