Forum Discussion
AndreaRoth
1 year agoNew Member
Many date fields
Hi everyone, I want to see how many contracts are active in a specific month. My data looks like that: contract_number rental_date_begin rental_date_end Booking_date 5651 24.01.2025 24....
- 1 year ago
Hi AndreaRoth
Assuming that the period of activity is from rental start to end date, try the following measure:
Count by Time Period = VAR StartDate = MIN ( Dates[Date] ) VAR EndDate = MAX ( Dates[Date] ) RETURN COUNTROWS ( FILTER ( 'Fact', 'Fact'[rental_date_begin] <= EndDate && 'Fact'[rental_date_end] >= StartDate ) )Note: You will need a disconnected dates table.
Please see the attached pbix.
MattiaFratello
1 year agoSuper User
Hi AndreaRoth , sorry but I didn't get your problem.
Can't you use your dim_calendar table to achiave what you need to do?
Using Calendar Year and Month Name?
| Date | Month | Calendar Year | MonthName |
| 01.02.2025 | 2 | 2025 | Feb |
| 02.02.2025 | 2 | 2025 | Feb |
| 03.02.2025 | 2 | 2025 | Feb |
| 04.02.2025 | 2 | 2025 | Feb |