Forum Discussion

andrewhann's avatar
andrewhann
Icon for Helper II rankHelper II
8 years ago
Solved

LAST DATE FROM FILTERED DATA

I am having trouble creating a last date from filtered data from QA Test results so that I can compare dates and select results only from the last test done:   My date looks like this:   TRREF...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi andrewhann,

     

    The formula below should work in this new scenario. :smileyhappy:

    Latest TRDATE_TRV =
CALCULATE (
    MAX ( Table1[TRDATE_TRV] ),
    ALLEXCEPT ( Table1, Table1[TRREF_TRV], Table1[QASPEC_TRV], Table1[QSCHARTCAT] )
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi andrewhann,

 

The formula below should work in this new scenario. :smileyhappy:

Latest TRDATE_TRV =
CALCULATE (
    MAX ( Table1[TRDATE_TRV] ),
    ALLEXCEPT ( Table1, Table1[TRREF_TRV], Table1[QASPEC_TRV], Table1[QSCHARTCAT] )
)

 

Regards

andrewhann's avatar
andrewhann
Icon for Helper II rankHelper II
8 years ago

Perfect.

 

Thank you.