You’re offline. This is a read only version of the page.
Announcements
Hi,
I have this formula trying to get the weeks for each Staff Name.
Filter('Scheduling List', 'Staff Name' = PersonID, Week)
The data would be like this -
| Staff Name | Week | Project |
| Louis Stevens | 2023_01_02 | abc |
| Louis Stevens | 2023_01_02 | def |
| Louis Stevens | 2023_01_02 | ghi |
| Louis Stevens | 2023_01_02 | jkl |
| Louis Stevens | 2023_01_02 | mno |
| Louis Stevens | 2023-01-09 | pqr |
| Louis Stevens | 2023-01-09 | stu |
| Ren Stevens | 2023-01-02 | abc |
But in my gallery is is showing every week,
How can I show the distinct Week for each person? Instead of it replicating many times for each Project?
thanks
Hi @wonka1234 ,
To display distinct weeks for each person in your gallery, you should use the Distinct() function along with Filter(). Your formula would look something like this:
Share
Report
920
All responses (
Answers (
Distinct(Filter('Scheduling List', 'Staff Name' = PersonID), Week)If you think my solution is helpful for you, then please accept it. 😊 Regards, Muhammad Mudassar Mazhar.
