Calculating Last 30-60 Days + % Per Day Period

[Yrstruly2021]

Please assist. I would like to calculate ...
Number of team members who have not used a PTO in the la...

https://drive.google.com/file/d/1loGG-cjGynvZyRMxasUEAWZalOhc_FCa/view?usp=sharing

And https://drive.google.com/file/d/1vGpgCu03WNcgcJtUH7yqH2sKTcYm5pPw/view?usp=sharing

[v-jayw-msft · Accepted solution]

Hi @Yrstruly2021 ,

Number of team members who have not used a PTO in the last 30, 60, 90 days:

Didn't find the total number in the sample data.

Number of team members who used more than 3 PTO in the last 90 days:

Measure = 
var _count = CALCULATE(COUNT('Sheet1 (2)'[LeaveTypeName]),FILTER(ALLEXCEPT('Sheet1 (2)','Sheet1 (2)'[Name]),'Sheet1 (2)'[LeaveStatus]="Approved"&&'Sheet1 (2)'[DateFrom]>=TODAY()-90))
return
CALCULATE(DISTINCTCOUNT('Sheet1 (2)'[Name]),FILTER('Sheet1 (2)',_count>3))

How many PTOs were cancelled:

cancelled = CALCULATE(COUNT('Sheet1 (2)'[LeaveTypeName]),FILTER(ALL('Sheet1 (2)'),'Sheet1 (2)'[LeaveStatus]="Cancelled by User"&&'Sheet1 (2)'[DateFrom]>=TODAY()-90))

How many were declined:

Rejected = CALCULATE(COUNT('Sheet1 (2)'[LeaveTypeName]),FILTER(ALL('Sheet1 (2)'),'Sheet1 (2)'[LeaveStatus]="Rejected"&&'Sheet1 (2)'[DateFrom]>=TODAY()-90))

How many were not actioned on:

Pending To Immediate Supervisor = CALCULATE(COUNT('Sheet1 (2)'[LeaveTypeName]),FILTER(ALL('Sheet1 (2)'),'Sheet1 (2)'[LeaveStatus]="Pending To Immediate Supervisor"&&'Sheet1 (2)'[DateFrom]>=TODAY()-90))

Best Regards,

Jay