cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Ronald123 Member
Member

Re: Matching transactions

@Zubair_Muhammad ,


When you have time to look at it?

Don't feel any pressure Smiley Happy

 

Greets,

 

Ronald

 

Super User
Super User

Re: Matching transactions

Hi @Ronald123 

 

My apologies for not getting back earlier

 

Try this DAX column. It works with sample data.

See if it performs better than M custom column

 

Calculated Column =
CALCULATE (
    MIN ( Test[Index] ),
    FILTER (
        Test,
        [Product] = EARLIER ( [Product] )
            && [Receiver] = EARLIER ( [Receiver] )
            && [Date] = EARLIER ( [Date] )
            && [TAG] = EARLIER ( [TAG] )
            && ABS ( [TIme] - EARLIER ( [TIme] ) )
                <= TIME ( 0, 2, 0 )
    )
)