How to have a running balance of distinct counts based on different column dates
Hi, I have a transaction table that has a start date and completion date columns. I need to determine the count of OPEN transactions per month. A transaction is considered open for a reference month if its start date is on or before that month, AND ( Completion date is either blank, OR its month is after the reference month). I have to have it in such a way, so when I plot its graph, report filters using the transaction table columns are still applicable. For example: the first table shows the data set, and the second table shows the expected Open ItemRunning Balance. The challenge I have is to come up with the correct measure so that it is report filterable on the fly. Thank you in advance.
