Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Filter a Table To Show Only Most Recent Date For Each Project

I have a table to be loaded into Power BI. There are 3 columns I am concerned with: Project_Name, Document_Name, Modified. The data in the table is something like this: | Project_Name | Docume...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Here we go:

    Measure = 
VAR maxd =
    CALCULATE (
        MAX ( 'Table'[Modified] ),
        ALLSELECTED ( 'Table' ),
        VALUES ( 'Table'[Project_Name] )
    )
RETURN
    IF ( MAX ( 'Table'[Modified] ) = maxd, 1, BLANK () )

     

    Pbix as attached.

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

Here we go:

Measure = 
VAR maxd =
    CALCULATE (
        MAX ( 'Table'[Modified] ),
        ALLSELECTED ( 'Table' ),
        VALUES ( 'Table'[Project_Name] )
    )
RETURN
    IF ( MAX ( 'Table'[Modified] ) = maxd, 1, BLANK () )

 

Pbix as attached.