Forum Discussion
checkner
2 years agoFrequent Visitor
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 ID | Anstellungsbeginn | Application Status |
| 123456 | Review | |
| 123457 | 01.01.2022 | Hired |
| 123458 | Review | |
| 123459 | Review | |
| 123460 | Review | |
| 123461 | Review | |
| 123462 | Review | |
| 123463 | Review | |
| 123464 | Review | |
| 123465 | Review | |
| 123466 | Review | |
| 123467 | Review | |
| 123468 | Review | |
| 123469 | Review | |
| 123470 | 15.01.2023 | Hired |
| 123471 | 20.01.2023 | Hired |
| 123472 | Review | |
| 123473 | Review | |
| 123474 | Review |
1 Reply
- Ashish_Mathur
Super User