Forum Discussion

dreyes6's avatar
dreyes6
Icon for Helper I rankHelper I
4 years ago

how to remove duplicates using the latest date?

Hello,   Anyone can you help me how to do i remove the duplicates using the lastes date. Any DAX form?    
dreyes6's avatar
dreyes6
Icon for Helper I rankHelper I
4 years ago

Impressive!!

 

Sorry for the question, but yes you absolutely understand it right.
Also I was thinking, lets say by not creating a new table, Is it possible to create an additional column

 

 

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    It is for creating new columns.

     

     

    New Last Modified Date CC =
    VAR currentproposal = Data[Proposals]
    VAR maxdate =
    MAXX (
    FILTER ( Data, Data[Proposals] = currentproposal ),
    Data[Last Modified Date]
    )
    RETURN
    IF (
    Data[Proposals] = currentproposal
    && Data[Last Modified Date] = maxdate,
    Data[Last Modified Date],
    BLANK ()
    )
     
    New Proposal Value CC =
    VAR currentproposal = Data[Proposals]
    VAR maxdate =
    MAXX (
    FILTER ( Data, Data[Proposals] = currentproposal ),
    Data[Last Modified Date]
    )
    RETURN
    IF (
    Data[Proposals] = currentproposal
    && Data[Last Modified Date] = maxdate,
    Data[Proposals],
    BLANK ()
    )