Forum Discussion
Datesbetween function not working with harvested slicers
Hi, I'm new to Power BI and trying to build a measure to calculate no. of records which have dates between week start date and week end date. I have created a slicer with calendar dates and harvest...
v-yadongf-msft
Here's my sample data.
Name Submitted date
| A | 12/09/2022 |
| B | 12/09/2022 |
| C | 12/11/2022 |
| D | 12/12/2022 |
| E | 12/13/2022 |
| F | 12/14/2022 |
| G | 12/10/2022 |
| H | 11/18/2022 |
| I | 12/03/2022 |
| J | 12/07/2022 |
| K | 12/12/2022 |
| L | 12/14/2022 |
| M | 12/14/2022 |
| N | 12/01/2022 |
Total Submissions between 12/04/2022 and 12/10/2022 should be 4 from the above sample data.
But its counting all the records (14) which is not the case.
I'm harvesting the slicer date ranges from above DAX (week start and week end dates) since the user should have the flexibility to choose the date ranges.