Forum Discussion

checkner's avatar
checkner
Frequent Visitor
2 years ago

Need help with Sameperiodlastyear

Hey,

I have the table below and would like to compare the hires from the set period with the last same period.
This works for the hires from the selected period, but unfortunately I get all hires for 2020/2021 and 2022 for the same period last year.

 

Yoy_Total Hired = 
CALCULATE(COUNT(Report[Candidate ID]), FILTER(Report, Report[Application Status]="Hired"))
YoY_Total Hired LY = 
CALCULATE(Count(Report[Candidate ID]), Filter(ALl(Report), Report[Application Status]="Hired"), SAMEPERIODLASTYEAR('Calendar (YoY Hires)'[Date].[Date]))

 

 

Candidate IDAnstellungsbeginnApplication Status
123456 Review
12345701.01.2022Hired
123458 Review
123459 Review
123460 Review
123461 Review
123462 Review
123463 Review
123464 Review
123465 Review
123466 Review
123467 Review
123468 Review
123469 Review
12347015.01.2023Hired
12347120.01.2023Hired
123472 Review
123473 Review
123474 Review