Forum Discussion
Solved
Countrows Outside date range in the slicer
Hello I have a file with employees data along with the StartDate and the FinishDate of each emloyee. Now the requirement is to count rows where the StartDate is BEFORE min date of the slicer...
Hi Sab
You need to use Filter in your calculate, try something like this:
Calculate([All rows], Filter(all(People Overview),People Overview[Start Date]<StartDate && People Overview[Finish Date]>EndDate))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi Sab
You need to use Filter in your calculate, try something like this:
Calculate([All rows], Filter(all(People Overview),People Overview[Start Date]<StartDate && People Overview[Finish Date]>EndDate))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!