Hi. I'm trying to get the average sales from 2015-2021 but it adds data from 2022.

[ZZZZZZZ37]

Hi. I'm trying to get the average sales from 2015-2021 but it adds data from 2022. How can I unfilter 2022 from the year so I will get the correct average sales?

For example on the 3rd row, average sales should be 27,785.86.

Thanks.

[PowerUserR · Accepted solution]

Okay, and is your data column marked as type "date"? 
If that is not the issue, could you please share some sample data and I'll try to help you.

[ZZZZZZZ37]

Hi again. 

I fixed my data type and it is now working fine.

Thank you for your help.

[PowerUserR]

Hi,

Average Sales (2015-2021)  = Calculate(AVERAGE('Table'[Sales]),Filter('Table','Table'[Date] < DATE(2022,01,01))

this should solve the issue.

[ZZZZZZZ37]

Hi, 

Thanks for your feedback. I tried to run this but I'm not getting any value. Sorry I'm new with power bi. Please see below.

Thanks.