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.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

You should be able to create a selector column or measure:

 

Column =
  VAR __Max = MAXX(FILTER('Table',[Project_Name] = EARLIER('Table'[Project_Name])),[Modified])

RETURN

  IF([Modified] = __Max,1,0)

 

Measure = 

  VAR __Max = MAXX(FILTER(ALL('Table'),[Project_Name = MAX('Table'[Project_Name]),[Modified])

RETURN

  IF(MAX([Modified]) = __Max,1,0)