Power BI DAX

[Anonymous]

Greetings, wonderful power bi community

Cant seem to work out how to solve this problem. 

Duplicate or updated entries should be discarded and only the latest one should be kept or flagged.
Example below: 

Attached sample table 

Thanks for your help 🙂 

[v-yinliw-msft]

Hi @Anonymous ,

You can try this method:

New a column:

Result =
VAR _latest =
    CALCULATE ( MAX ( 'Table'[createdon] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )
VAR _count =
    CALCULATE ( COUNT ( 'Table'[Name] ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )
RETURN
    IF ( 'Table'[createdon] = _latest && _count > 1, "Latest", BLANK () )

The result is:

Hope these help you.

Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Yinliw
It does work when you have date set as date but i need it to include date and time as some records have entries on the same date but at different time. 
Is this something that can be done? 

Many thanks

[v-yinliw-msft]

Hi @Anonymous ,

I change some data to take a test(I change the Kia):

If I understand you correctly, it still works fine.

Hope these help you.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I think it doesnt work for me as i have  more that just a singl day.

My dataset contains 65k rows for every day of the year, date is effective date or activity date. 
Created on a date when activity that will take place is created by someone and always have Date of when it will go ahead. 

https://1drv.ms/u/s!ArHGcaxRBasHgZhNA2KFN538CYVhqA

I have shared pbix file to show the data that i have. 

Many thanks