Hi there,
i have this calendar where I want to show only events where the Subject contains the word “Booking”
At the moment the function of “Circle2” on visible is:
CountRows(Filter(MyCalendarEvents; DateValue(Text(Start)) = DateAdd(_firstDayInView;ThisItem.Value;Days))) > 0 && !Subcircle1.Visible && Title2.Visible
How can I modify the function to also have the filter that shows me the events that contain the word "Booking" of the subject?
All the best
Solved! Go to Solution.
@Z_BI
Try this
CountRows(
Filter(
MyCalendarEvents,
DateValue(Text(Start)) = DateAdd(
_firstDayInView,
ThisItem.Value,
Days
),
"Booking" in Subject
)
) > 0 && !Subcircle3.Visible && Title25.Visible
@Z_BI
Try this
CountRows(
Filter(
MyCalendarEvents,
DateValue(Text(Start)) = DateAdd(
_firstDayInView,
ThisItem.Value,
Days
),
"Booking" in Subject
)
) > 0 && !Subcircle3.Visible && Title25.Visible
User | Count |
---|---|
162 | |
96 | |
76 | |
72 | |
59 |
User | Count |
---|---|
213 | |
166 | |
97 | |
95 | |
78 |