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

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

Helper II

8 years ago

Thank you for that - it works perfectly as requested.

One further extension required - I need the last date for each TRREF for multiple TRREFs:

TRREF	TRDATE	QSCHARTCAT	TRVALUE	QASPEC_TRV	Latest TRDATE_TRV
P/716202	08/08/2017 07:09	Q33	82.82	471808_QC	31/08/2017 10:35	08/08/2017 07:09
P/717351	04/08/2017 01:33	Q33	82.4	471808_QC	31/08/2017 10:35	04/08/2017 01:33
P/717352	04/08/2017 01:33	Q33	82.26	471808_QC	31/08/2017 10:35	04/08/2017 01:33
P/717353	07/08/2017 15:45	Q33	81.49	471808_QC	31/08/2017 10:35	07/08/2017 15:45
P/717354	04/08/2017 01:32	Q33	82.9	471808_QC	31/08/2017 10:35	04/08/2017 01:32
P/717356	01/08/2017 08:43	Q33	85.6	471808_QC	31/08/2017 10:35	08/08/2017 07:09
P/717356	08/08/2017 07:09	Q33	83.02	471808_QC	31/08/2017 10:35	08/08/2017 07:09
P/717357	01/08/2017 12:17	Q33	85.2	471808_QC	31/08/2017 10:35	04/08/2017 04:48
P/717357	04/08/2017 04:48	Q33	82.57	471808_QC	31/08/2017 10:35	04/08/2017 04:48
P/717859	01/08/2017 16:50	Q33	84	471808_QC	31/08/2017 10:35	08/08/2017 07:09
P/717859	08/08/2017 07:09	Q33	82.16	471808_QC	31/08/2017 10:35	08/08/2017 07:09
P/717860	02/08/2017 16:48	Q33	84.6	471808_QC	31/08/2017 10:35	08/08/2017 07:09
P/717860	08/08/2017 07:09	Q33	82.07	471808_QC	31/08/2017 10:35	08/08/2017 07:09

So that I can then filter for the last test for each TRREF where TRDATE = LatestTRDATE

Thank you in advance for your help.

v-ljerr-msft

Microsoft 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
Helper II
8 years ago
andrewhann
Helper II
8 years ago
Perfect.

Thank you.

Forum Discussion

LAST DATE FROM FILTERED DATA

Related content

Date filters for Visualization

Filtered Date

Between date filter with fixed start date and latest end date

Removing date filter

Creating a Date Filter in Power BI