Forum Discussion

LostinDaxland's avatar
LostinDaxland
Regular Visitor
2 years ago
Solved

DAX Help! Return Latest Date, but stop after finding first value

Hi - I'm really hoping that I can get some help here. I've been banging my head against the wall a while trying to figure this out. Please go easy on me - I'm very new to DAX (or any kind of coding.....
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    LostinDaxland , Try using below DAX

     

    Latest Invoice =
    VAR maxDate =
    CALCULATE(
    MAX(Trial[Invoice Date]),
    ALLEXCEPT(Trial, Trial[Project Number])
    )
    VAR minInvoiceID =
    CALCULATE(
    MIN(Trial[Invoice ID]),
    ALLEXCEPT(Trial, Trial[Project Number]),
    Trial[Invoice Date] = maxDate
    )
    RETURN
    IF(
    Trial[Invoice Date] = maxDate && Trial[Invoice ID] = minInvoiceID,
    "Latest Invoice",
    BLANK()
    )

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

LostinDaxland , Try using below DAX

 

Latest Invoice =
VAR maxDate =
CALCULATE(
MAX(Trial[Invoice Date]),
ALLEXCEPT(Trial, Trial[Project Number])
)
VAR minInvoiceID =
CALCULATE(
MIN(Trial[Invoice ID]),
ALLEXCEPT(Trial, Trial[Project Number]),
Trial[Invoice Date] = maxDate
)
RETURN
IF(
Trial[Invoice Date] = maxDate && Trial[Invoice ID] = minInvoiceID,
"Latest Invoice",
BLANK()
)

LostinDaxland's avatar
LostinDaxland
Regular Visitor
2 years ago

Thank you! This worked perfectly!