topic Re: how to remove duplicates using the latest date? in DAX Commands and Tips

how to remove duplicates using the latest date?

dreyes6 — Tue, 01 Mar 2022 17:55:22 GMT

Hello,

Anyone can you help me how to do i remove the duplicates using the lastes date. Any DAX form?

Re: how to remove duplicates using the latest date?

Jihwan_Kim — Tue, 01 Mar 2022 17:29:57 GMT

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]

)

Re: how to remove duplicates using the latest date?

dreyes6 — Tue, 01 Mar 2022 17:56:40 GMT

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

Re: how to remove duplicates using the latest date?

Jihwan_Kim — Tue, 01 Mar 2022 17:49:26 GMT

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 ()

)