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.
Hello,
I've got a products table.
I've got a users tables with user name, company name and other fields .
Users subscribe to one or more products, so i've got a UsersProducts table which links Products and Users.
When a user subscribes to a product, I set the Enddate to '31/12/2030'. When the user cancel subscription, I change the EndDate.
UserID | ProductID | StartDate | EndDate |
1 | 1 | 5-1-2020 | 31-12-2030 |
1 | 2 | 25-1-2020 | 14-6-2020 |
3 | 2 | 2-2-2020 | 31-12-2030 |
4 | 3 | 15-12-2019 | 1-4-2020 |
I would like the report user to select a date in a calendar list (I will display latest day of each month in this list) and the user will get the number of subscribers per company for each product at that particular date.
I will use a Matrix to show this information, but I can't find how to correctly fiter per date and group datas per company
The only way I found was to pre-populate another table, which would be repopulated each night. I'm quite sure there is a more clever and dynamic way to do that but I've spend hours to find it.
Thank you for any help
@lfrancfort , please refer to the blog on a similar topic
Check how to find active between two dates
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |