Creating a "Weekly" Aggregation

[Anonymous]

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 solution]

Hi @Anonymous

You could add this column to your Date/Calender table and add it to the axis of your visual.  

Week Starting = DATEADD(
                    'Dates'[Date],
                    1-WEEKDAY('Dates'[Date])
                    ,DAY
                    )

[Anonymous]

Say I wanted to pick a different day how could I do that ?