Forum Discussion

S2861926's avatar
S2861926
Regular Visitor
4 years ago

How to correlate more rows in the same table with unique ID

Hi, in a table (SQL database) I have the double-entry bookkeeping (accounting movements) as shown in the attached figure:                           I want to correlate all the mo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI S2861926,

It seems like you want to use the customer code to register with all movements descriptions, then you can simply summary these records with specific customers.

If that is the case, I'd like to suggest you create a calculated column to loop records based on the current 'registration ID' group to find out the corresponding user to tag these records.

User =
CALCULATE (
    CONCATENATEX ( VALUES ( 'Table'[Description] ), [Description], "," ),
    FILTER (
        'Table',
        'Table'[Registration ID] = EARLIER ( 'Table'[registration ID] )
            && SEARCH ( "33.05.11", 'Table'[Account Code], 1, -1 ) > 0
    )
)

Regards,

Xiaoxin Sheng