How to calculate number of values between two column dates

[mikah]

Hi everyone,

I have here a table with the job added and the job expiry date (note: job added and job expiry date is in a different column in the same table)

What I wanted to happen is that I wanted to count the number of job id before the job expiration date regardless of the status, when I use the filter date

Thanks in advance, if someone is in help.

[Ashish_Mathur]

Hi,

If you want to count all jobs before the expiration date, then why are you selecting 2 dates in the slicer? 

[v-jingzhang]

Hi @mikah 

Your Date slicer is based on Job Added Date or Job Expiration Date? As you want to count the number of jobs before the Job Expiration date, if the date slicer is picking the job expiration date column, do you want to count the number of jobs whose job expiration date is before the maximum date (1/3/2023) or the mininum date (1/10/2022) from the slicer? 

I guess probably this is what you want?

Number of Jobs = COUNTROWS(FILTER('Table','Table'[Job Added Date]<=MIN('Date'[Date]) && 'Table'[Job Expire Date]>=MAX('Date'[Date])))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.