Forum Discussion
Solved
Count Lastest Records Before Selected Date
Hello community, I have the follwoing data model: Date (1-*) Employees (1-*) Events. Sample data from Employees: End of Month Employee ID Employee Status Labour Type 7/31/20...
Hi,
See if my solution in this PBI file helps.
Expected outcome, I want to be able to showcase this:
| Date | People Count | Active People |
12/31/2025 | 2 | 1 (only 51115216 is active, 92999434 latest record is Unactive) |
| 1/31/2024 | 2 | 1 |
| 2/29/2024 | 2 | 1 |
| 3/31/2024 | 2 | 1 |
| 4/30/2024 | 2 | 1 |
| 5/31/2024 | 2 | 1 |
| 6/30/2024 | 2 | 1 |
| 7/31/2024 | 2 | 1 |
| 8/31/2024 | 2 | 1 |
| 9/30/2024 | 2 | 1 |
| 10/31/2024 | 2 | 1 |
| 11/30/2024 | 2 | 1 |
| 12/31/2024 | 2 | 1 |
| 1/31/2025 | 2 | 1 |
| 2/28/2025 | 2 | 1 |
| 3/31/2025 | 3 | 1 |
| 4/30/2025 | 3 | 1 |
| 5/31/2025 | 3 | 1 |
| 6/30/2025 | 3 | 1 |
| 7/31/2025 | 4 | 2 |
| 8/31/2025 | 4 | 1 |
| 9/30/2025 | 4 | 1 |
.... and so on
Ashish_Mathur
Super User
Super UserHi,
See if my solution in this PBI file helps.