Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I am trying to create a measure of the membership of an organisation as a time-series. For each record of member, we have a field for 'Joined Date' and 'Valid to Date' (either the date their membership ended or the time in future their membership is valid to) Ideally I would like to create a column which has the cumulative number of members at the point that the particular member joined.
I have seen solutions using DAX for versions creating a cumulative tally of sales, however this wouldn't work exactly, as the members who have left previous to that point in time need to be removed from the tally.
Any help would be gratefully received.
Kind regards
Robin
Solved! Go to Solution.
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |