How to determine the contract is active or not use start and end date?
Hi everyone, I am doing an ACV analysis and want to mimic what we have in Excel. We have a table which is the contract dataset. And in Excel, we have a formula like below. By comparing to Start and End date, we determine if the contract is active in a specific month. If it's active, it has the ACV in that month. In power BI, if I have the Contract Database and A Date table by month, how can I calculate if the contract is active in a specific month and sum up the ACV? And if anyone is doing an ACV analysis in Power BI, do you have any suggestion?
