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.
Anonymous
1 year agoNot applicable
Hi AndreaRoth ,
Did the replies above offered help you solve the problem, if it helps, you can consider to accept it as a solution so that more user can refer to, or if you have other problems, you can offer some information so that can provide more suggestion for you.
Best regards,
Lucy Chen