- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count of members per month based on start and end dates and date dimension
HI,
I have this requirement where I need to calculate count of members per month based on start and end dates.
ex: If a member's plan start on 01/01/2021 and plan ends on 03/31/2021 then this member has to be counted in Jan member counts, Feb member counts and march.
So, I have a members table with columns "member_id", "plan start date" and "plan end date" and a date dimension table which I created in power bi data model with columns "date", "year", "month", "year-month."
In the modeling tab I created a relationship on "Plan start date" in members table and "date" on date dimension with cardinality many to many and cross filter direction to both(not sure if its right).
I have created a seperate measure to calculate the member count"

Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |