DAX gives error

[Anonymous]

hello everyone,

Right now i have this formula;

but i dont know what is wrong with it. I think there goes something wrong with the filter function, because i didn't give a filterExpression. I don't what to do here and don't know what to fill in to make this formule work.

Can anyone help me?

[amitchandak · Accepted solution]

@Anonymous , move datesbetween ouside the filter, or give table name as first argument  (all three places)

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please try to replace " filter(datesbetween " to "datesbetween", and delete one of )s in each ending part of if function.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[amitchandak · Accepted solution]

@Anonymous , move datesbetween ouside the filter, or give table name as first argument  (all three places)