Forum Discussion
Cumulative value for dynamic date range
I have a Calendar table and two more tables:
1. Offer table w/columns: Offer code, Customer code, Offer value.
2. Opportunity table w/columns: Opp code, Opp Start Date, Opp End date, Customer code
I need to calculate the cumulative value of offers at any given date for valid opportunities (that is between Start and End date).
Any bright ideas?
8 Replies
Thimios ,
Can you share sample data and sample output. Make me @
Appreciate your Kudos.
Very similar case it discussed in my blog : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Appreciate your Kudos.
Might take a look at Open Tickets, it was designed to work with date intervals. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147
Hi Thimios ,
I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
