brendalpzm
Board Regular
- Joined
- Oct 3, 2022
- Messages
- 59
- Office Version
- 365
- 2021
- 2019
- 2016
- Platform
- Windows
I am creating a week view calendar with a vertical gallery,
This gallery is linked to a SharePoint list where I have the date slots until july 20, 2024.
I applied a filter to the gallery to show only the 7 days according to the month showing.
The issue is that when I change to the next week, it only shows a few items and the next next week it doesn't show anything, and so on. I notice a pattern that this current week according to today() date and previous ones they do show but the rest don't.
The formula I used in the verticall gallery is
This gallery is linked to a SharePoint list where I have the date slots until july 20, 2024.
I applied a filter to the gallery to show only the 7 days according to the month showing.
The issue is that when I change to the next week, it only shows a few items and the next next week it doesn't show anything, and so on. I notice a pattern that this current week according to today() date and previous ones they do show but the rest don't.
The formula I used in the verticall gallery is
Power Query:
(Filter(Slots_ZDP_Pychologistt, DateValue(DateSchedule) <= DateAdd(_FirstDayofWeek+6,ThisItem.Value-1,TimeUnit.Days) &&
DateValue(DateSchedule) >= DateAdd(_FirstDayofWeek,ThisItem.Value-1,TimeUnit.Days)))
