Forum Discussion
Count rows in a date-range.
I have a Members table:
| Member ID | Member Type |
| 101 | Type-1 |
| 102 | Type-2 |
| 103 | Type-3 |
| 104 | Type-1 |
and a memberships table:
Membership ID | Member ID | Membership Start Date | Membership End Date |
| 1 | 101 | 1/1/2023 | 3/31/2023 |
| 2 | 102 | 2/1/2023 | 2/20/2023 |
| 3 | 103 | 1/15/2023 | 1/31/2023 |
| 4 | 104 | 2/20/2023 | 3/20/2023 |
I want to create a table that calculates how many members had a membership in each month:
| Membership active month. | Member Type. | Number of Members |
| Jan-23 | Type-1 | 1 |
| Jan-23 | Type-3 | 1 |
| Feb-23 | Type-1 | 2 |
| Feb-23 | Type-2 | 1 |
| Mar-23 | Type-1 | 2 |
How do I do this in Power BI?
No need to have separate tables for member type.
1 Reply
No need to have separate tables for member type.