Forum Discussion
Summing Hourly Data from One Table with a Fixed Hour Block
Hi all,
I am trying to aggregate impressions from an hourly table (left table), into a time block table (right table).
Essentially, I want to total the hourly data into the time blocks from the From Hour - To Hour columns.
Many thanks for all the help!
4 Replies
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi,
The WeTransfer link to the sample data is here: https://we.tl/t-NDtWQ0vuaH
In one table, we have impressions broken down by the individual hour, but I'd like to group them up into their own time blocks.
For example, on Fridays, hours 0 = 108 impr, hours 1 = 126, and hours 2 = 125 in one table.
In another table, I have a "From Hour" and "To Hour" columns.
So the results for an "From Hour" = 0 and "To Hour" = 2 would say 359 impressions (108+126+125).
The two tables are linked by campaign name/campaign ID.
Happy to share any additional details.You have provided a little too much detail. Can you please indicate which two tables you mean?
The two tables are linked by campaign name/campaign ID.Side note: you will want to do is to adjust your data model
Please identify which tables are facts and which are dimensions. Please do not use bidirectional search unless there is a dire need for it.
