Forum Discussion
Summarize date with a timestamp into a single date
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.
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.
2 Replies
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.
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 .
