Forum Discussion
Solved
Measure to count transactions between date fields
Hi I need to create a new measure which can be used to show a count of business that has been cancelled before it has been taken up but after it as been agreed. I have the following fields which ...
I should also add that I am trying to create a measure which shows:
=CALCULATE([POLICY_TRANSACTION_COUNT], WHEN IT OCCURS WITHIN THE 14 DAYS AFTER [INCEPTION DATE]
AND ALSO
= CALCULATE([POLICY_TRANSACTION_COUNT], WHEN IT OCCURS AFTER 14 DAYS FROM [INCEPTION DATE]