Forum Discussion
The True/False expression does not specify a column. Each True/False expressions used as a table
I have issue with my dax expression with this error message "The True/False expression does not specify a column. Each True/False expressions used as a table filter express must refer to exactly one...
Okay, so the issue is with your filter in your CALCULATE expression:
FILTER( Sales[Type] IN {"Online", "Shop"}), EDATE(mindate, -11), maxdate)The syntax should be FILTER(Table, Filter Expression) so I think your first one should be
FILTER('Sales', [Type] IN {"Online", "Shop"})You've then got two more filters with no expression so it can't evaluate them.EDATE(mindate,-11) < this is just going to return a date, it's not evaluating to a true or false.maxdate < again this is just going to return your max date, not evaluate anything.I can't work out what you are trying to do but should EDATE(mindate,-11) = maxdate ? i.e. is that a rogue comma that should be something else?
Okay, so the issue is with your filter in your CALCULATE expression:
FILTER( Sales[Type] IN {"Online", "Shop"}), EDATE(mindate, -11), maxdate)
The syntax should be FILTER(Table, Filter Expression) so I think your first one should be
FILTER('Sales', [Type] IN {"Online", "Shop"})
You've then got two more filters with no expression so it can't evaluate them.
EDATE(mindate,-11) < this is just going to return a date, it's not evaluating to a true or false.
maxdate < again this is just going to return your max date, not evaluate anything.
I can't work out what you are trying to do but should EDATE(mindate,-11) = maxdate ? i.e. is that a rogue comma that should be something else?