Summarize date with a timestamp into a single date

[Anonymous]

Hi

Most likely super easy to do but I can't figure it out yet.

I have a column with a timestamp like
"12/04/2020 10:12:43PM"
"12/04/2020 10:12:45PM" etc.

I need to be able to summarize all these into 1 singe day column. So I could show in my table SUM of this days transactions instead of showing all from the same day.

[HarishKM]

@Anonymous  Hey can extract date from that 

or 

you can change the format of your date time and you can use summarize function as well to create a new table then you will get summarize date table .

[amitchandak · Accepted solution]

@Anonymous , Create a date column like this and use

Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))

also, To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.