Forum Discussion
jakeryan56
4 years agoAdvocate II
Dax Help!
I have a list of monthly recurring revenue payments and the start date/end date for these payments. I have a MonthList table and would like to show the SUM of all recurring payments that are within the range of the selected MonthName.
There is already a relationship between the ManagedServices [StartDate] field and Calendar [Date] but can't figure out how to show all the "active" payments for the selected month.
I know I haven't explained this very well but hopefully this makes sense!
 
 
jakeryan56 , I have a blog on a similar topic. check if this blog can help
2 Replies
- amitchandakSuper User
jakeryan56 , I have a blog on a similar topic. check if this blog can help
- jakeryan56Advocate II
You're the best! This is the exact same problem you have solved in your blog 🙂