AnonymousNot applicable6 years agoSolvedCalculate Syntax Hi, Could somebody please help me with my syntax? The first part works fine, but the Bank Holiday part won't seem to count properly. I want it to look at all start dates and if it lands on a ...Show MoreFowmy6 years agoAnonymous Try like: (Replace Table and Column namesMeasure: COUNTROWS( INTERSECT(VALUES('Table1'[Date]),VALUES('Table2'[DATE])) ) ________________________Did I answer your question? Mark this post as a solution, this will help others!.I accept KUDOS ☺YouTube | LinkedIn
Fowmy6 years agoAnonymous Try like: (Replace Table and Column namesMeasure: COUNTROWS( INTERSECT(VALUES('Table1'[Date]),VALUES('Table2'[DATE])) ) ________________________Did I answer your question? Mark this post as a solution, this will help others!.I accept KUDOS ☺YouTube | LinkedIn
Fowmy6 years agoAnonymous Try like: (Replace Table and Column namesMeasure: COUNTROWS( INTERSECT(VALUES('Table1'[Date]),VALUES('Table2'[DATE])) ) ________________________Did I answer your question? Mark this post as a solution, this will help others!.I accept KUDOS ☺YouTube | LinkedIn
FowmySuper User to Anonymous6 years agoAnonymous You are welcome!________________________Did I answer your question? Mark this post as a solution, this will help others!.I accept KUDOS 🙂YouTube | LinkedIn
Related contentSyntax problemSQL Query Syntax issueGetting syntax error when calculating averagecalculate syntaxSQL syntax error
