Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Creating a "Weekly" Aggregation

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 ...
Need Help
Show and Tell
Tips and Tricks
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    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
                    )
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

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