Forum Discussion

ThomasJB2004

Regular Visitor

2 years ago

Solved

Filtering out all False values from my Table

I need to sort the date according to unique numbers (sort of ID), when the ID is detected twice i need the ID with the newest date attached to it. i fixed this with a DAX now the newest date will alw...

Need Help

Tips and Tricks

Anonymous
2 years ago
Hi ThomasJB2004 ,

You can follow the steps below to get it, please find the details in the attachment.

1. Create a calculated column to judge if it is the row with max date per ID

Flag = VAR _maxdate = CALCULATE ( MAX ( 'Table'[Date] ), FILTER ( 'Table', 'Table'[id] = EARLIER ( 'Table'[ID] ) ) ) RETURN IF ( 'Table'[Date] = _maxdate, TRUE(), FALSE() )

2. Create a slicer to filter the data

Best Regards
Filtering out all False values from my Table.pbix41 KB

Anonymous

Not applicable

2 years ago

Hi ThomasJB2004 ,

You can follow the steps below to get it, please find the details in the attachment.

1. Create a calculated column to judge if it is the row with max date per ID

Flag = 
VAR _maxdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( 'Table', 'Table'[id] = EARLIER ( 'Table'[ID] ) )
    )
RETURN
    IF ( 'Table'[Date] = _maxdate, TRUE(),  FALSE() )

2. Create a slicer to filter the data

Best Regards

Filtering out all False values from my Table.pbix41 KB