Creating a "Weekly" Aggregation

Question

I am currently working with a dataset which represents daily performance of a specific aspect of our business.

In the image below, I am using my "Date" field on the shared axis. (Formatted as "Date" NOT "Date Hierarchy"). This works fine for the daily trend.

I am looking to also aggregate this by Week, Sunday through Saturday. Ideally, I could have weekly performance also trended so I can see performance week over week as a trend.

What is the best way to create a weekly aggregation that is Sunday through Saturday and incorporate this into a dashboard for users?

Thanks for the input!

phil_seamark · Accepted Answer

Hi&nbsp;Anonymous&nbsp;You could add this column to your Date/Calender table and add it to the axis of your visual. &nbsp;&nbsp;Week Starting = DATEADD(
                    'Dates'[Date],
                    1-WEEKDAY('Dates'[Date])
                    ,DAY
                    )

Forum Discussion

Creating a "Weekly" Aggregation

2 Replies

Related content

creating an aggregated table

How to create drill-down matrix hierarchy with pre-aggregated data without double-counting?

Data Aggregation issue

Create line chart without aggregation

Aggregate