HEP WITH DAX FORMULA

[Limit Braker]

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.

Please, thanks

 

[Limit Braker]

BUMP

 

[sandy666]

try to use BUMP after 24 hours
give people a chance to read your post

 

[mamady]

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)))

Please try and advise