average in the form of a line on the chart

[Datanik]

I'm trying to show the average for the last 90 days as a straight line on the chart, but I only get a moving average. Do you have any ideas how this can be done in a straight line? I will be grateful for any help.

average 3 month =

VAR NumOfMonths = 90

VAR LastCurrentDate = MAX ( perf[Date] )

return

CALCULATE(AVERAGEX(perf,perf[clickk]), DATESINPERIOD (perf[Date], LastCurrentDate, - NumOfMonths, day ))

[Shaurya · Accepted solution]

Hi @Datanik,

Calculate average for the entire duration that you want and ignore any filter context in that measure. Then add a constant line in your visual from the Analytics Pane by using that measure.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts