Format Date_Time

You are seeing multiple dates because you simply changed the display or formatting but not the actual data type. Several methods to extract the date:

Hi Khomotjo ,

Thanks to danextian  and uzuntasgokberk  for their quick answers. I have some other thoughts to add:
(1) Here is my test data.

(2) Create a calculation table. Select the Date column to change the data type.

Table =
ADDCOLUMNS (
    SUMMARIZE ( 'Table_3', [FinalisedDate], [id] ),
    "date",
        DATE ( YEAR ( [FinalisedDate] ), MONTH ( [FinalisedDate] ), DAY ( [FinalisedDate] ) )
)

Best Regards,

Neeko Tang

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