Forum Discussion
DAX gives error
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?
Anonymous , move datesbetween ouside the filter, or give table name as first argument (all three places)
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
2 Replies
- amitchandak
Super User
Anonymous , move datesbetween ouside the filter, or give table name as first argument (all three places)
- Jihwan_Kim
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