Forum Discussion
Helper Istart date and end date range selection to get count
Instead of
CALENDAR([start-date],[end-date])
you can use a list
{[start-date],[end-date]}
if you really want to check only for these two dates.
Super UserYou need to use a disconnected calendar table for this.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Helper I
| ID | Requestor Name | LineManager | start-date | end-date | RWWithin24Hr | RWWorkigOption | RWMonday | RWTuesday | RWWednesday | RWThursday | RWFriday |
| 6630 | MD | CS | 01/02/2025 | 12/03/2025 | TRUE | FALSE | FALSE | TRUE | FALSE | TRUE | |
| 7022 | NS | CS | 27/02/2025 | 10/03/2025 | TRUE | TRUE | TRUE | TRUE | TRUE | TRUE | |
| 7616 | SR | CS | 24/04/2025 | 09/05/2025 | TRUE | TRUE | TRUE | TRUE | TRUE | TRUE | |
| 6412 | PP | CS | 01/01/2025 | 27/06/2025 | TRUE | FALSE | FALSE | FALSE | TRUE | TRUE | |
| 6420 | CD | CS | 02/01/2025 | 27/06/2025 | TRUE | FALSE | FALSE | FALSE | TRUE | TRUE | |
| 6424 | SV | CS | 02/01/2025 | 27/06/2025 | TRUE | FALSE | FALSE | FALSE | TRUE | TRUE | |
| 7629 | NM | CS | 23/04/2025 | 30/06/2025 | TRUE | TRUE | TRUE | TRUE | TRUE | TRUE |
When a user select a date range from 01-03-2025 to 30-04-2025 then any employee who's start date falls inbetween the date range or earlier showed be shown and also who's end date falls inbetween or greater should be shown , for example here Chintan is doing work from home 02/01/2025 till 27/06/2025 that mean he falls between the date range of 01-03-2025 to 30-04-2025
| 6420 | CD | CS | 02/01/2025 | 27/06/2025 |
- lbendlin
- chintusasmal123
Now if I select date range from 01/04/2025 to 30/06/2025 , I'm getting wrong value rather I should have got 5 all record either start date or end date falls in that range
- lbendlin
Instead of
CALENDAR([start-date],[end-date])
you can use a list
{[start-date],[end-date]}
if you really want to check only for these two dates.