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?

 

 

3 Replies

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

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

    It is for creating a new table.

     

     

    New Table =
    CALCULATETABLE (
    Data,
    TREATAS (
    GROUPBY (
    Data,
    Data[Proposals],
    "@latestdate", MAXX ( CURRENTGROUP (), Data[Last Modified Date] )
    ),
    Data[Proposals],
    Data[Last Modified Date]
    )
    )
  • 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 ()
      )