Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 date is an holiday. I've did this with
Holiday = IF(CONTAINS(CalendarEntry;CalendarEntry[StartTime];'Date'[Date]);"Yes";"No")
That works fine but I've got a problem that I've got Dutch and German Holidays in the same table (in 'CalendarEntry'[StartTime]). So I need to filter them ... The name (text) I can use is in CalendarEntry'[ModifiedBy] but I've tried a lot but no succes 😞
Anyone?
Because of my regional settings I need to use ; instead of ,
Solved! Go to Solution.
Try
Holiday = IF ( CONTAINS ( FILTER ( CalendarEntry; CalendarEntry[ModifiedBy] = "German" ); CalendarEntry[StartTime]; 'Date'[Date] ); "Yes"; "No" )
Hope this helps
David
Try
Holiday = IF ( CONTAINS ( FILTER ( CalendarEntry; CalendarEntry[ModifiedBy] = "German" ); CalendarEntry[StartTime]; 'Date'[Date] ); "Yes"; "No" )
Hope this helps
David
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |