Forum Discussion

angelikakolacz's avatar
angelikakolacz
Icon for Helper I rankHelper I
4 years ago

Search with multiple criteria

Hello, I have a table with more than milion rows with data from different customers. I’m looking for a dax formule that gives me the following result (see column output):   ACCOUNT NUMBER INVO...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

Based on what I see in the sample, I tried to write DAX formula like below in order to create a calculated column.

Please check the below picture and the attached pbix file.

 

 

Output CC =
VAR _result =
    SUMMARIZE (
        FILTER (
            Data,
            Data[ACCOUNT NUMBER] = EARLIER ( Data[ACCOUNT NUMBER] )
                && Data[PERIODE] = EARLIER ( Data[PERIODE] )
                && Data[INVOICE AMOUNT]
                    = -1 * EARLIER ( Data[INVOICE AMOUNT] )
        ),
        Data[INVOICE NUMBER]
    )
RETURN
    _result + 0