Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
@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 .
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |