Forum Discussion
Count active items (contrats) between two dates using groups
I have the duration of contracts, with start date and end date, and each of these contracts has other columns that detail who sold, which region...
I created a monthly calendar table to know the active contracts in each month, however this does not show me the amount of active contracts in each month having this subdivision with quantities by region, or by person who hired.
I need to create a chart with these active contracts each month but that changes quantities when I move the filter by region, buyers, or any other characteristic that a contract may have.
Can someone help me? I have no idea.
This seems to be a dax problem, could you add more details? pls read this article, https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2001860#M754454
Any question, please let me know. Looking forward to receiving your reply.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
This seems to be a dax problem, could you add more details? pls read this article, https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2001860#M754454
Any question, please let me know. Looking forward to receiving your reply.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.