Reference Line - Average - After a Date

[jerryr125]

Hi -

On a line chart I have the following reference line for the average :

=Avg(aggr(sum(QuantitySold), [SalesDate]))

How can I calculate the average after a specific sales date only, such as 10/25/2020 ?

Thoughts  ? Thanks - jerry

[Kushal_Chawda · Accepted solution]

@jerryr125  like below

=Avg({<[SalesDate]={">=10/25/2020"}>}aggr(sum({<[SalesDate]={">=10/25/2020"}>}QuantitySold), [SalesDate]))

[jerryr125]

Excellent - Thank you very much - Jerry