ConcatenateX helper calculated column to identify matching debit and credit balance only once

[DataNinja777]

Hello,

I have a data with matching debit and credit balances in the past months record where the current month balance is only with debit balances and I need to prepare bookkeeping for matching credit balance entry.  I'd like to match off the debit and credit balances in the past month without aggregating but Power Pivot's default behavior is that numbers needs to be aggregated in a measure without appropriate granurality row context.  In order to show unique number of matching debit and credit, I have calculated a helper column like below.  As I have circled sample of matching pairs below, I'd like to match off only pairs of matching debits and credits and not more than 2 index numbers should appear in the helper column.  I'd appreciate it if you could let me know how I can just show matching pairs without concatenating 3rd onwards index numbers in the helper column below.  I am guessing something like a virtual table to order debit and credit balances line by line with matching index numbers will do the job.  

To get the above helper column I've written the following dax formula.  

Thank you for your help!

[danextian]

Hi @DataNinja777 

Can you please post a usable sample data (not an image) that covers your use case and your expected result from that data? What you posted seems to be just a snippet of the data as your formula are referencing other columns.

Additional questions:

show matching pairs without concatenating 3rd onwards index  -  What is the third index? How do you determine so.

How to determine if they're matching? Match this row against which row?