cancel
Showing results for
Did you mean:
New Member

Hello, I have data with the date/time that a sale occurred, and I need to make a table that gathers sales for all days of a certain time interval.
For example:
10/10/2020 09:15 = \$50
11/10/2020 09:40 = \$150
12/10/2020 09:50 = \$50
10/13/2020 10:09 = \$350

In the break:
- 9:00 am to 10:00 am sold in total = \$250
- 10:00 am to 11:00 am sold in total = \$350

1 ACCEPTED SOLUTION
Super User IV

@Felipe_Nery , You can create a time table with buckets and use that. First split date and time from datetime in power query or DAX.

In DAX

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

DateTime.Date([datetime])

Time = [datetime].Time
or
Time = Time(hour([datetime]),minute([datetime]),second([datetime]))

Create a time table join with time and use that

https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

time([Hour],0,0) & " - " time([Hour]+1,0,0)

sort this on hour if needed

Proud to be a Super User!

2 REPLIES 2
Super User IV

@Felipe_Nery , You can create a time table with buckets and use that. First split date and time from datetime in power query or DAX.

In DAX

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

DateTime.Date([datetime])

Time = [datetime].Time
or
Time = Time(hour([datetime]),minute([datetime]),second([datetime]))

Create a time table join with time and use that

https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

time([Hour],0,0) & " - " time([Hour]+1,0,0)

sort this on hour if needed

Proud to be a Super User!

New Member

Thank you, I spent days trying. I am Brazilian, and here I didn't find any tutorial about it.

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors