Count rows in a date-range.

[Anonymous]

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?

[lbendlin · Accepted solution]

No need to have separate tables for member type.