The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all!
I have tried to illustrate what I want to do using MS Excel. Say that we have 2 columns with sales timestamps of 2 products.
How can we plot the count of these timestamps in a single table using specific time buckets?
Example below:
DATA | PRODUCT on Power BI | ||||
Item 1 Sales Time Bucket | Item 2 Sales Time Bucket | Time Buckets | Item Sales 1 | Item Sales 2 | |
12:05 | 05:45 | 00:00 | 0 | 0 | |
15:45 | 19:14 | 01:00 | 0 | 0 | |
12:05 | 05:45 | 02:00 | 0 | 0 | |
15:45 | 19:14 | 03:00 | 0 | 0 | |
12:05 | 05:45 | 04:00 | 0 | 0 | |
15:45 | 19:14 | 05:00 | 0 | 9 | |
12:05 | 05:45 | 06:00 | 0 | 0 | |
15:45 | 19:14 | 07:00 | 0 | 0 | |
12:05 | 05:45 | 08:00 | 0 | 0 | |
15:45 | 19:14 | 09:00 | 0 | 0 | |
12:05 | 05:45 | 10:00 | 0 | 0 | |
15:45 | 19:14 | 11:00 | 0 | 0 | |
12:05 | 05:45 | 12:00 | 9 | 0 | |
15:45 | 19:14 | 13:00 | 0 | 0 | |
12:05 | 05:45 | 14:00 | 0 | 0 | |
15:45 | 19:14 | 15:00 | 9 | 0 | |
12:05 | 05:45 | 16:00 | 0 | 0 | |
15:45 | 19:14 | 17:00 | 0 | 0 | |
18:00 | 0 | 0 | |||
19:00 | 0 | 9 | |||
20:00 | 0 | 0 | |||
21:00 | 0 | 0 | |||
22:00 | 0 | 0 | |||
23:00 | 0 | 0 | |||
23:59 | 0 | 0 |
Solved! Go to Solution.
@airportGR I created a solution in this file:
Time Bucket Count.pbix
@airportGR I created a solution in this file:
Time Bucket Count.pbix
Thank you very very much guys!
@airportGR
my pleasure 🙂
Hey, check out my showcase report - got some high level stuff there 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up if you liked it 🙂
Hi @ManguilibeKAO , yes.
The output is the second table, the count of the 2 different timestamp columns based on provided time buckets.
Hi,
Ok, I see. In this second table, only the column Time Buckets is filled. Could you also fill the the columns Item Sales 1 and Item Sales 2?
Best regards.
Done @ManguilibeKAO . The second table is a count of the two columns based on provided time buckets.
Hi,
You have given us the input. Could you provide the output you want, given this input?
Best regards.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |