cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Subscriptions start and end dates for each user, # of subscriptions per company on specific dates

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.

 

UserIDProductIDStartDateEndDate
115-1-202031-12-2030
1225-1-202014-6-2020
322-2-202031-12-2030
4315-12-20191-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

1 REPLY 1
Highlighted
Super User IV
Super User IV

Re: Subscriptions start and end dates for each user, # of subscriptions per company on specific date

@lfrancfort , please refer to the blog on a similar topic

Check how to find active between two dates

 

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors