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?    
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]
)
)