Forum Discussion
Solved
Rankx: Finding the Last Transaction per Contract within a Date Period
Good day all, I have a table with multiple banking transactions in per contract. A batch of transactions is run on a pecific date for multiple contracts. The client wants to see what all the last...
parry2k thank you for your response and proposed solution.
The [Last Transaction Date] measure works well and after I applied it to a batch with relevant filters, it produced the correct detail as expected.
However, after applying the [Count by Status] measure, it only counts 1 instance it seems of each status, the result being:
When it should be as follows based on the detail:
