Using invoice # to create an invoice date column

[pcuezze]

I have a single table that contains both charges and payments tied to an Invoice #. The date field shows the date of the ledger transaction (be it charge or payment)  I would like to create a calculated column that populates each record with the date of the charge.  See below for what I'm trying to accomplish.  Thank you, everyone, again, in advance, for your assistance.

[TeigeGao · Accepted solution]

Hi @pcuezze ,

We can use the following DAX query:

Date of Service =
CALCULATE (
    MIN ( 'Transaction Table'[Date of Trx] ),
    FILTER (
        ALL ( 'Transaction Table' ),
        'Transaction Table'[Invoice#] = EARLIER ( 'Transaction Table'[Invoice#] )
            && 'Transaction Table'[Trx Type] = "Charge"
    )
)

The result will like below:

Best Regards,

Teige