Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate 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 ...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    Try like: (

    Replace Table and Column names

    Measure:

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , have flag that 1 on back holiday 'and try like

 

if(CALCULATE(COUNT([New Start Date]), FILTER('Bank Holidays', 'Bank Holidays'[Flag] = 1)) >=1,1,0)

or

if(CALCULATE(COUNT([New Start Date]), FILTER('Bank Holidays', 'Bank Holidays'[Flag] = 1)) >=1,1,0) +0