Getting a value based on the MAX Date

[bhmiller89]

I have a dataset that includes columns "Invoice Date" and "InvoiceAmt". I want to show the InvoiceAmt of the most recent Invoice (MAX Invoice Date) So that I can compare it to the Moving 3 Month Average of InvoiceAmt (Already calculated) 

[Mariusz · Accepted solution]

Hi @bhmiller89 

You can try the below for your MAX

Sales Last Invoice = 
CALCULATE(
    [Sales], -- this where you place your InvoiceAmt 
    TREATAS( 
        LASTDATE( Sales[OrderDateKey] ), -- this is where you place your Invoice Date
        'Calendar'[Date] 
    )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.