Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

If contains function with a filter

Hi, I've got a holiday table with dates (like xmas) which is an import of SQL and I've got a own created date table (with weekdays, month, date from Date Dimension table). Now I want to know which...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    9 years ago

    Try

     

    Holiday =
IF (
    CONTAINS (
        FILTER ( CalendarEntry; CalendarEntry[ModifiedBy] = "German" );
        CalendarEntry[StartTime]; 'Date'[Date]
    );
    "Yes";
    "No"
)

     

    Hope this helps
    David

dedelman_clng's avatar
dedelman_clng
Community Champion
9 years ago

Try

 

Holiday =
IF (
    CONTAINS (
        FILTER ( CalendarEntry; CalendarEntry[ModifiedBy] = "German" );
        CalendarEntry[StartTime]; 'Date'[Date]
    );
    "Yes";
    "No"
)

 

Hope this helps
David

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi David,

     

    Thnx for your reply

    I've tried the folowing code (copy of your code and replace the filter value)

    Holiday = 
IF (
    CONTAINS (
        FILTER ( CalendarEntry; CalendarEntry[ModifiedBy] = "Esther");
        CalendarEntry[StartTime]; 'Date'[Date]
    );
    "Yes";
    "No"
)


    And it works :-) Thnx for helping me!

    I've made a picture of the result (for privacy, I've stripped the surnames and I've create some slicers to reduce the results)