# HEP WITH DAX FORMULA

#### Limit Braker

##### New Member
Hi guys,

I want to get an average depending of the "year"(column) by dividing a certain amount of days by the sales.

heres moreorless the funciton i came up with but it keep saying its wrong, am i filtering the wrong way?

=IF(FACTSALES[Año]=2019,[Sum of Value]/365,IF(FACTSALES[Año]=2018,[Sum of Value]/365,IF(FACTSALES[Año]=2017,[Sum of Value]/245,0)

Any suggestions on how to do it better?

Error message:
This formula is invalid or incomplete: 'The expression is not valid or appears to be incomplete. Please review and correct the expression.
The end of the input was reached.

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

BUMP

#### sandy666

##### Well-known Member
try to use BUMP after 24 hours

##### Board Regular
If I understood your data set structure, I think the below is your desired formula

=IF(FACTSALES[Ano]=2019,SUM(FACTSALES[Value]/365,IF(FACTSALES[Ano]=2018,SUM(FACTSALES[Value]/365,IF(FACTSALES[Ano]=2017,SUM(FACTSALES[Value]/245,0)))

Replies
3
Views
5K