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
chintusasmal123ID 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-20256420 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