search with multiple criteria

Hi, angelikakolacz 

Your problem can be solved with a simple calculation column.

Column = 
Var Output=CALCULATE (
    MAX ( 'Table'[INVOICE NUMBER] ),
    FILTER (
        'Table',
        [ACCOUNT NUMBER] = EARLIER ( 'Table'[ACCOUNT NUMBER] )
            && [PERIODE] = EARLIER ( 'Table'[PERIODE] )
            && [INVOICE AMOUNT] = - EARLIER ( 'Table'[INVOICE AMOUNT] )
    )
)
Return
IF(Output=BLANK(),0,Output)

Considering that your quantity is relatively large, you can also use measure to solve this problem.

Measure:

Output = 
Var Output=CALCULATE (
    MAX ( 'Table'[INVOICE NUMBER] ),
    FILTER (
        ALL('Table'),
        [ACCOUNT NUMBER] = SELECTEDVALUE( 'Table'[ACCOUNT NUMBER] )
            && [PERIODE] = SELECTEDVALUE( 'Table'[PERIODE] )
            && [INVOICE AMOUNT] = - SELECTEDVALUE( 'Table'[INVOICE AMOUNT] )
    )
)
Return
IF(Output=BLANK(),0,Output)

Hope that helps you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.