Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
7 years ago
Solved

Getting a value based on the MAX Date

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) 

Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    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.
    Mariusz Repczynski


     

1 Reply

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    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.
    Mariusz Repczynski